服务端代码:
package com.wsexample;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
public class ConnectDB {
public Connection dbConn;
public ConnectDB(){
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; //加载 JDBC 驱
动
String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=card"; // 连接服务器
和数据库 test
String userName = "cui"; //默认用户名
String userPwd = "123"; //安装 sql server 2005 时的密码
try {
Class.forName(driverName);
dbConn = (Connection) DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println("Connection Successful!"); //如果连接成功 控制台输出 Connection
Successful!
}
catch (Exception e) {
e.printStackTrace();
System.out.println("Connection fail!");
}
}
// public static void main(String args[]){
// ConnectDB c=new ConnectDB();
//
//
// }
}
package com.wsexample;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
评论0