userupdate.java

手工完成

package Bean;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class UserUpdate {
	Connection conn = null;
	
//	conn.createStatement().executeUpdate("insert into UsersTable(ID, userName, passWord) values('aaa','bbb','aaa')");
public void update(UserBean user)
{
	conn = new DBConn().getConn();
	String sql = null;
//	sql = "UPDATE INTO users (userName, password,gender,email,telphone,money,usertype) VALUES (?,?,?,?,?,?,?)";
	sql = "UPDATE users SET password = ?,gender = ?,email = ?,telphone = ? WHERE username = ?";
	try {
		PreparedStatement ps=conn.prepareStatement(sql);
		
		ps.setString(1, user.getPassword());
		ps.setString(2, user.getGender());
		ps.setString(3, user.getEmail());
		ps.setString(4, user.getTelphone());
		ps.setString(5, user.getUsername());
		
		ps.executeUpdate();//
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
}
}