JDBC.ODBC连接数据库代码

数据库产品：Microsoft SQL 2000

1.导入数据库：jia服装公司销售系统

2.建立数据源：jia

3.代码如下：

importjava.sql.*;//longlongagobynothing!
publicclassconnDatabase{
ResultSetrs;
Statementstmt;
Connectioncon;
Stringsqlstr="";
publicstaticvoidmain(String[]args)throwsException{
newconnDatabase();
}
connDatabase(inta)throwsException{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:jia","sa","123");
}
//构造连接数据库
connDatabase()throwsException{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Stringurl="jdbc:odbc:jia";
Stringuser="sa";
Stringpass="123";
con=DriverManager.getConnection(url,user,pass);
System.out.println("连接数据库成功.........");
}
//tTransaction
publicvoidforTransaction(Stringsql)throwsException{
con=DriverManager.getConnection("jdbc:odbc:jia","sa","123");
con.setAutoCommit(false);
stmt=con.createStatement();
stmt.addBatch(sql);
stmt.addBatch(sql);
stmt.addBatch(sql);
stmt.executeBatch();
con.commit();
con.setAutoCommit(true);
}
//查询
publicResultSetqueryDB(Stringsql)throwsException{
stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
//查询表中的所有记录
rs=stmt.executeQuery(sql);
returnrs;
}
//更新
publicbooleanupdateDB(Stringsql)throwsException{
stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
if(stmt.executeUpdate(sql)<=0)
{
returnfalse;
}
else
returntrue;
}
//关闭连接
publicvoidconClose()throwsException{
con.close();
}
}