JBUILDER 2007 学习笔记

最新推荐文章于 2025-08-06 08:20:19 发布

原创最新推荐文章于 2025-08-06 08:20:19 发布 · 524 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#jbuilder #sql #string #exception #sqlserver #microsoft

学习讨论区专栏收录该内容

37 篇文章

订阅专栏

本文分享了作者从使用JBuilder2005过渡到JBuilder2007的心得体会，并详细介绍了如何利用JBuilder2007进行数据库连接与基本操作的方法，包括插入、查询、更新及删除等核心功能。

经过两个月的学习现在总对Jbuilder 2007有点感觉了，学习Java时开始，我选择的是Jbuilder 2005。后发现出了新的了。叫2007下来一下。妈呀！全不一样。。我重学呀！不过还好。他功能强呀。。。不比。NET差。

我用了好久才学会使用数据库。现将代码贴如下：

package news;

//sql_data.java
import java.sql.*;
public class sql_data {
String sDBDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url ="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=InfoSite";
//pubs为你的数据库的
String user = "sa";
String password = "sa";
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
public sql_data() {
  try {
   Class.forName(sDBDriver);
  } catch (java.lang.ClassNotFoundException e) {
   System.err.println("sql_data(): " + e.getMessage());
  }
}
public void executeInsert(String sql) {
  try {
   //conn = DriverManager.getConnection(url,user,password);
   conn = DriverManager.getConnection(url, user, password);
   stmt = conn.createStatement();
   stmt.executeUpdate(sql);
   stmt.close();
   conn.close();
  } catch (SQLException ex) {
   System.err.println("sql_data.executeUpdate:" + ex.getMessage());
  }
}
public ResultSet executeQuery(String sql) {
  try {
   conn = DriverManager.getConnection(url, user, password);
   stmt =
    conn.createStatement(
     ResultSet.TYPE_SCROLL_SENSITIVE,
     ResultSet.CONCUR_READ_ONLY);
   rs = stmt.executeQuery(sql);
  } catch (SQLException ex) {
   System.err.println("sql_data.executeQuery:" + ex.getMessage());
  }
  return rs;
}
public void executeUpdate(String sql) {
  try {
   conn = DriverManager.getConnection(url, user, password);
   stmt = conn.createStatement();
   stmt.executeUpdate(sql);
   stmt.close();
   conn.close();
  } catch (SQLException ex) {
   System.err.println("aq.executeQuery: " + ex.getMessage());
  }
}
public void executeDelete(String sql) {
  try {
   conn = DriverManager.getConnection(url, user, password);
   stmt = conn.createStatement();
   stmt.executeUpdate(sql);
   stmt.close();
   conn.close();
  } catch (SQLException ex) {
   System.err.println("sql_data.executeDelete:" + ex.getMessage());
  }
}
public void closeStmt() {
  try {
   stmt.close();
  } catch (SQLException e) {
   e.printStackTrace();
  }
}

public void closeConn() {
  try {
   conn.close();
  } catch (SQLException e) {
   e.printStackTrace();
  }
}

/*
*
用于测试数据库是否通
public static void main(String avg[]){
sql_data db=new sql_data();
String sql="select* from admin";
ResultSet rs=db.executeQuery(sql);
try {
  while (rs.next()){
   System.out.print(rs.getString("adminuser"));
   System.out.println(rs.getString("adminpass"));
  }

} catch (Exception e) {
  // TODO: handle exception
}

}
*/
}