62,615
社区成员
发帖
与我相关
我的任务
分享
Connection con=null;
private String url="jdbc:microsoft:sqlserver://localhost:1433;database=aa;";
private String sid;
private String userName ="sa";
private String sqlpass ="";
private String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
if(e.getSource()==regBtn){
this.getinfo();
String sName=name.trim();
String sPassword=password.trim();
String sSex=sex.trim();
String sAge=age.trim();
String sEmail=email.trim();
try{
Class.forName(driver); //指定JDBC驱动程序
con = DriverManager.getConnection(url,userName,sqlpass);
PreparedStatement prs=con.prepareStatement("insert into mydb(id,password,sex,age,email) values(?,?,?,?,?)");
prs.setString(1,sName);
prs.setString(2,sPassword);
prs.setString(3,sSex);
prs.setString(4,sAge);
prs.setString(5,sEmail);
prs.executeUpdate();
JOptionPane.showMessageDialog(this,"注册成功");
con.close();
}
catch(ClassNotFoundException ec){
System.out.println(ec) ;
}
catch(SQLException es){
System.out.println(es) ;
}
catch(Exception ee){
System.out.println(ee) ;
}
}
public class Connection_Database {
//加载驱动
private final String DBDRIVER="com.microsoft.jdbc.sqlserver.SQLServerDriver";
//连接数据库的路径
private final String DBURL="jdbc:microsoft:sqlserver://localhost:1433;databasename=pubs";
//连接数据库的用户名
private final String DBUSER="sa";
//连接数据库的密码
private final String DBPASSWORD="sa";
//连接数据库的对象
private Connection conn=null;
public Connection_Database(){
try{
Class.forName(DBDRIVER);
this.conn=DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);
}catch (Exception e){
e.printStackTrace();
}
}
//取得数据库连接
public Connection getConnection(){
return this.conn;
}
//关闭数数据库连接
public void close(){
try{
this.conn.close();
}catch(Exception e){}
}
}