1，布局如下 2,所用数据库:mysql 版. Drop table if exists `user`; CREATE TABLE `user` ( `id` int(10) unsigned NOT NULL auto_increment, `username` varchar(50) NOT NULL default '', `password` varchar(10) default NULL, `email` varchar(50) default NULL, PRIMARY KEY (`id`), UNIQUE KEY `ID` (`id`), KEY `ID_2` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=78 ; Insert into user values(10,"shi","123","456"); 3.DBAccess.java package com.demo.javabean; import java.sql.DriverManager; import java.sql.SQLException; import com.mysql.jdbc.Connection; import com.mysql.jdbc.ResultSet; import com.mysql.jdbc.Statement; public class DBAccess { private String drv="com.mysql.jdbc.Driver"; private String url="jdbc:mysql://localhost:3306/demo"; private String usr="root"; private String pwd=""; private Connection conn=null; private Statement stm=null; private ResultSet rs=null; public String getDrv() { return drv; } public void setDrv(String drv) { this.drv = drv; } public String getUrl() { return url; } public void setUrl(String url) { this.url = url; } public String getUsr() { return usr; } public void setUsr(String usr) { this.usr = usr; } public String getPwd() { return pwd; } public void setPwd(String pwd) { this.pwd = pwd; } public Connection getConn() { return conn; } public void setConn(Connection conn) { this.conn = conn; } public java.sql.Statement getStm() { return stm; } public void setStm(Statement stm) { this.stm = stm; } public java.sql.ResultSet getRs() { return rs; } public void setRs(ResultSet rs) { this.rs = rs; } //创建数据库连接函数 public boolean createConn() { boolean b=false; try{ Class.forName(drv).newInstance(); conn=(Connection) DriverManager.getConnection(url,usr,pwd); b=true; }catch(SQLException e){ }catch(ClassNotFoundException e){ }c...
