Question

求 Java通讯录连接数据库的代码

这个程序可以连接数据库的Java通讯录

Answer 1

package y2javaee.xmal1.common;import java.sql.*;public class DBConnection {

private static Connection conn; private static final String DRIVER_CLASS = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; private static final String DATABASE_URL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=addressBook"; private static final String DATABASE_USRE = "sa"; private static final String DATABASE_PASSWORD = "120010"; /**
* 返回连接
*
* @return Connection
*/
public static Connection getConnection() { try {
Class.forName(DRIVER_CLASS);
conn = DriverManager.getConnection(DATABASE_URL,
DATABASE_USRE, DATABASE_PASSWORD); } catch (Exception e) {
e.printStackTrace();
} return conn;
} /**
* 关闭数据库连接
*
*/
public static void closeConnection(){
try{
if(conn!=null)
conn.close();
}catch(Exception e){
e.printStackTrace();
}
}
/**
* 关闭Statement对象
*
* @param stm
*/
public static void closeStatement(Statement stm){
try{
if(stm!=null)
stm.close();
}catch(Exception e){
e.printStackTrace();
}
}
/**
* 关闭PreparedStatement对象
*
* @param ps
*/
public static void closeStatement(PreparedStatement ps){
try{
if(ps!=null)
ps.close();
}catch(Exception e){
e.printStackTrace();
}
}
/**
* 关闭ResultSet结果集对象
*
* @param rs
*/
public static void closeResultSet(ResultSet rs){
try{
if(rs!=null)
rs.close();
}catch(Exception e){
e.printStackTrace();
}
}
}

Answer 2

联系Q二七四二三三六七二..