1.在src下建包,然后包中建javabean类,代码如下(我的包名为aa)
package aa;
import java.sql.*;
public class bean {
private final String dbDriver ="com.microsoft.sqlserver.jdbc.SQLServerDriver"; //连接sql数据库的方法
private final String url ="jdbc:sqlserver://localhost:1433;DatabaseName=student";
private final String userName = "sa";
private final String password = "1";
private Connection con = null;
private Statement stmt = null;
public bean() {
try {
Class.forName(dbDriver).newInstance(); //加载数据库驱动
} catch (Exception ex) {
System.out.println("数据库加载失败");
}
}
//创建数据库连接
public boolean creatConnection() {
try {
con = DriverManager.getConnection(url, userName, password);
<