幫我補全這個java，mysql數據庫的代碼。。謝謝

public void addUser(String username,String password,String sex)

{

ConnectDatabase();

if (conn != null) {

ResultSet rset = null;

PreparedStatement preStmt = null;

conn .setAutoCommit(false);

preStmt = con

.prepareStatement("insert into user (username,password,sex) values(?,?,?)");

preStmt.setString(1, username);

preStmt.setString(2, password);

preStmt.setString(3, sex);

rset = preStmt.executeUpdate();

conn.commit();

closeDataBase();

}

}

public void updateUser(String id,String username,String password,String sex)

{

ConnectDatabase();

if (conn != null) {

ResultSet rset = null;

PreparedStatement preStmt = null;

conn .setAutoCommit(false);

preStmt = con

.prepareStatement("update user set username=?,password=?,sex=? where id=?");

preStmt.setString(1, username);

preStmt.setString(2, password);

preStmt.setString(3, sex);

preStmt.setString(4, id);

rset = preStmt.executeUpdate();

conn.commit();

closeDataBase();

}

}

上一篇:微商引流加人方法

下一篇:形容女子笑容甜美的詩句