1,布局如下
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;
sql.jdbc.Connection;
sql.jdbc.ResultSet;
sql.jdbc.Statement;
public class DBAccess {
private String drv="sql.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) {
= 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) Connection(url,usr,pwd);
b=true;
}catch(SQLException e){
}catch(ClassNotFoundException e){
}catch(InstantiationException e){
}catch(IllegalAccessException e){
}
return b;
}
//更新sql函数
public boolean update (String sql)
{
boolean b=false;
try{
stm=(Statement) ateStatement();
ute(sql);
b=true;
}catch(Exception e){
}
return b;
}
青少年科技报
//查询sql函数
public void query (String sql)范世康
{
try{
stm=(Statement) ateStatement();
rs=(ResultSet) uteQuery(sql);
}catch(Exception e)
{
}
}
public boolean next()
{
boolean b=false;
try{
())b=true;
}
catch(Exception e)
{
}
return b;
}
榆林杀人案
public String getValue(String field)
{
String value=null;
try{
if(rs!=null)String(field);
}catch(Exception e)
{
}
return value;
}
肝脓疡
public void closeRs()
{
try{
if(rs!=null)
rs.close();
}
catch(SQLException e)
{
}
}
public void closeStm()
{
try{
if(rs!=null)
stm.close();
}
catch(SQLException e)
诚成文化