tomcat中配置SQL Server的JDBC连接
解压缩文件,找到jtds-1.2.jar文件,复制到tomcat安装路径下的commonlib目录中
以下是示例代码,红色部分根据具体情况修改:
package database;
import java.sql.*;
public class Access {
String sDBDriver = “net.sourceforge.jtds.jdbc.Driver”;
String sConnStr = “jdbc:jtds:sqlserver://localhost:1433;DatabaseName=student;User=lhj;Password=lhj”;
Connection conn = null;
ResultSet rs = null;
public void shutcon(){
try{
conn.close();
System.out.println(“connection closed.”);
}
catch(SQLException ex) {
System.err.println(“shutcon():”+ex.getMessage());
}
}
public Access() {
try {
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e) {
System.err.println(“access(): ” + e.getMessage());
}
}
public ResultSet executeQuery(String sql) {
rs = null;
try {
conn = DriverManager.getConnection(sConnStr);
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println(“aq.executeQuery: ” + ex.getMessage());
}
return rs;
}
public int executeUpdate(String sql) {
int result = 0;
try {
conn = DriverManager.getConnection(sConnStr);
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
result = stmt.executeUpdate(sql);
}
catch(SQLException ex) {
System.err.println(ex.getMessage());
}
return result;
}
}