import java.sql.*;
import javax.naming.*; public class DBconnBean { java.sql.Connection conn = null;
javax.sql.DataSource ds = null;
java.sql.ResultSet rs = null; public DBconnBean () {
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=user"; String user = "sa";
String password = "521301";
conn= DriverManager.getConnection(url,user,password); }catch(Exception e) {
conn = null;
System.out.print("Error To Create connection");
}
}
public ResultSet executeQuery(String sql) {
rs=null;
try {
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
} catch (SQLException ex) {
conn = null ;
rs = null;
System.err.println("execute-Query: "+ex.getMessage());
}
return rs; } public int executeUpdate(String sql) {
try {
Statement stmt=conn.createStatement();
stmt.executeUpdate(sql);
return 1;
} catch (SQLException ex) {
conn = null;
System.err.println("execute-Update: "+ex.getMessage());
return 0;
}
}}
import javax.naming.*; public class DBconnBean { java.sql.Connection conn = null;
javax.sql.DataSource ds = null;
java.sql.ResultSet rs = null; public DBconnBean () {
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=user"; String user = "sa";
String password = "521301";
conn= DriverManager.getConnection(url,user,password); }catch(Exception e) {
conn = null;
System.out.print("Error To Create connection");
}
}
public ResultSet executeQuery(String sql) {
rs=null;
try {
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
} catch (SQLException ex) {
conn = null ;
rs = null;
System.err.println("execute-Query: "+ex.getMessage());
}
return rs; } public int executeUpdate(String sql) {
try {
Statement stmt=conn.createStatement();
stmt.executeUpdate(sql);
return 1;
} catch (SQLException ex) {
conn = null;
System.err.println("execute-Update: "+ex.getMessage());
return 0;
}
}}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货