ResultSet rs=null;
static MyConnection instance=null;
public MyConnection() {
init();
}
public void init() //用来初始化MyConnection类的函数
{
try {
Class.forName("com.mysql.jdbc.Driver");
conn=(Connection) DriverManager.getConnection("jdbc:mysql://IP地址/数据库名称","数据库授权的用户名","密码");
System.out.println(conn);
} catch (ClassNotFoundException ex) {
Logger.getLogger(MyConnection.class.getName()).log(Level.SEVERE, null, ex);
} catch (SQLException ex) {
Logger.getLogger(MyConnection.class.getName()).log(Level.SEVERE, null, ex);
}
}
public static MyConnection getInstance(){
if(instance==null)
instance=new MyConnection();
return instance;
}
public void insert(WndMembers member) throws SQLException //定义一个插入函数,参数是由数据库生成的实体类对象
{
init(); //在插入函数中执行初始化
String username=member.getWndMembersname();
String pw=member.getWndMemberspw(); //接收从Servlet传过来的参数
String sql ="insert into wnd_members(wnd_membersname,wnd_memberspw) values(?,?)"; //定义sql语句
System.out.println(sql);
stat=conn.prepareStatement(sql);
stat.setString(1, username);
stat.setString(2, pw);
stat.executeUpdate(); //执行插入操作
if(stat!=null){stat.close();}
}
}