//以下是该部分函数代码函数
public String userSignup(User newuser){
String message="No";
//连接数据库
Connection con=null;
PreparedStatement sqluser=null;
ResultSet rsuser=null;
try{
Class.forName("com.mysql.jdbc.Driver");
}
catch(ClassNotFoundException e){
e.printStackTrace();
System.out.println("驱动加载错误");
}
try{
String url = "jdbc:mysql://localhost:3306/mydatabase";
con = DriverManager.getConnection(url, "root", "root");
sqluser = con.prepareStatement("insert into mydatabase.user_table(iduser,pwduser,nameuser) values(?,?,?)");
sqluser.setString(1,newuser.getUserid());
sqluser.setString(2,newuser.getUserpwd());
sqluser.setString(3,newuser.getUsername());
System.out.println(sqluser);
message="ok";
con.close();
System.out.println("执行完");
}
catch(SQLException e){e.printStackTrace();}
return message;
}
//以下是控制台输出信息,是获取到了的
com.mysql.jdbc.JDBC4PreparedStatement@10cecb2: insert into mydatabase.user_table(iduser,pwduser,nameuser) values('10123456789','123456','李霞')
小妹新人一枚,感谢各位帮忙了!
