package oa;
import java.sql.*;
public class DBConn {
String sDBDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String sConnStr = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=office";
Connection conn = null;
ResultSet rs = null;
int rs2=0;
public DBConn()
{
try {
Class.forName(sDBDriver);
conn = DriverManager.getConnection(sConnStr,"center","center");
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("faq(): " + e.getMessage());
}
catch(SQLException ex)
{
System.err.println("aq.executeQuery: " + ex.getMessage());
}
}
public int executeUpdate(String sql)
{
try
{
Statement stmt = conn.createStatement();
rs2=stmt.executeUpdate(sql);
}
catch(SQLException ex)
{
System.err.println("aq.executeQuery: " + ex.getMessage());
}
return rs2;
}
public ResultSet executeQuery(String sql)
{
rs = null;
try
{
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println("aq.executeQuery: " + ex.getMessage());
}
return rs;
}
}
调试了一下午
刚开始调executeQuery
成功后调试executeUpdate
可是怎么都不行
最后baidu
java.lang.NoSuchMethodError executeUpdate
结果问题是
有可能是TOMCAT在你更改以后没有检测到类文件的更新,把WORKS目录下的东西都删除,重新启动服务器试试.