sqlserver2005 连接数据库代码 public class DatabaseM { private Connection con=null;
public final static String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver"public final static StringURL= "jdbc:sqlserver://localhost:1434;DatabaseName=family_financial;";
public class DatabaseM { private Connection con=null;
public final static String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver"public final static StringURL= "jdbc:sqlserver://localhost:1434;DatabaseName=family_financial;";
public DatabaseM () throws SQLException{
try {
Class.forName(DRIVER);
this.con=DriverManager.getConnection(URL,"sa","123");
System.out.println(con);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public Connection getConnection(){
return this.con;
}
public void colse(){
try {
this.con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void main(String [] agrs){
try {
new DatabaseM().getConnection();
} catch (SQLException e) {
e.printStackTrace();
}
}
}添加代码
String sql="insert into Mevnber(call,name,birthday,motto)values(?,?,?,?)";
PreparedStatement ps=null;
DatabaseM dbc=null;
try{
//System.out.println("jdhfdjhfj");
dbc=new DatabaseM();
ps=dbc.getConnection().prepareStatement(sql);
ps.setString(1, member.getCall());
ps.setString(2, member.getName());
ps.setString(3, new Date( member.getBirthday().getTime()).toString());
ps.setString(4, member.getMotto());
ps.executeUpdate();
System.out.print("添加成功");
}catch(Exception ee){
ee.printStackTrace();
}
错误信息
com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset
另外，你这里面对connection是重用的：
public Connection getConnection(){
return this.con;
}同时还提供了关闭方法：
public void colse(){
try {
this.con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}那么一旦被关闭，后续就不能使用了。
此外，连接不应该这样被重用，这个设计很不合理，建议每次都是新获取连接；每次操作完毕都应关闭连接；长时间连接不关闭，数据库可能都会关闭它。