注册登录案例用MVC和mysql_java简单的MVC实现简单的用户注册与登录

importjava.sql.DriverManager;importjava.sql.ResultSet;importcom.mysql.jdbc.Connection;importcom.mysql.jdbc.PreparedStatement;public classDbDao {privateConnection conn;privateString driver;privateString url;privateString username;privateString pass;publicDbDao(){

}publicDbDao(String driver, String url, String username, String pass) {this.driver =driver;this.url =url;this.username =username;this.pass =pass;

}publicConnection getConn() {returnconn;

}public voidsetConn(Connection conn) {this.conn =conn;

}publicString getDriver() {returndriver;

}public voidsetDriver(String driver) {this.driver =driver;

}publicString getUrl() {returnurl;

}public voidsetUrl(String url) {this.url =url;

}publicString getUsername() {returnusername;

}public voidsetUsername(String username) {this.username =username;

}publicString getPass() {returnpass;

}public voidsetPass(String pass) {this.pass =pass;

}//get database connection

public Connection getConnection() throwsException {if(conn == null){

Class.forName(this.driver);

conn= (Connection) DriverManager.getConnection(url, username, this.pass);

}returnconn;

}//insert records

public boolean insert(String sql, Object... args) throwsException{

PreparedStatement pstmt=(PreparedStatement) getConnection().prepareStatement(sql);for(int i = 0; i < args.length; i++) {

pstmt.setObject(i+ 1, args[i]);

}if(pstmt.executeUpdate() != 1)return false;return true;

}//execute query

public ResultSet query(String sql, Object...args) throwsException{

PreparedStatement pstmt=(PreparedStatement) getConnection().prepareStatement(sql);for(int i=0; i< args.length; i++) {

pstmt.setObject(i+1, args[i]);

}returnpstmt.executeQuery();

}public void modify(String sql, Object...args) throwsException{

PreparedStatement pstmt=(PreparedStatement)getConnection().prepareStatement(sql);for(int i = 0; i< args.length; i++) {

pstmt.setObject(i+1, args[i]);

}

pstmt.executeUpdate();

pstmt.close();

}public void closeConn() throwsException{if(conn != null && !conn.isClosed())

conn.close();

}

}