java增删改查代码_Java web 简单的增删改查程序(超详细)

就是简单的对数据进行增删改查。代码如下：

1.bean层：用来封装属性及其get set方法 toString方法，有参构造方法，无参构造方法等。

public classBean {private intid;privateString name;privateString password;privateString sex;public intgetId() {returnid;

}public void setId(intid) {this.id =id;

}publicString getName() {returnname;

}public voidsetName(String name) {this.name =name;

}publicString getPassword() {returnpassword;

}public voidsetPassword(String password) {this.password =password;

}publicString getSex() {returnsex;

}public voidsetSex(String sex) {this.sex =sex;

}

@OverridepublicString toString() {return "Bean [id=" + id + ", name=" + name + ", password=" + password + ", sex=" + sex + "]";

}public Bean(intid, String name, String password, String sex) {super();this.id =id;this.name =name;this.password =password;this.sex =sex;

}publicBean() {//TODO Auto-generated constructor stub

}

}

2.DBUtil:对数据库连接关闭操作的封装：

importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;public classDBUtil {private static String url = "jdbc:mysql://localhost:3306/db10?useUnicode=true&characterEncoding=utf8";private static String user = "root";private static String password = "root";private static String jdbcName="com.mysql.jdbc.Driver";private Connection con=null;public staticConnection getConnection() {

Connection con=null;try{

Class.forName(jdbcName);

con=DriverManager.getConnection(url, user, password);//System.out.println("数据库连接成功");

} catch(Exception e) {//TODO Auto-generated catch block//System.out.println("数据库连接失败");

e.printStackTrace();

}returncon;

}public static voidclose(Connection con) {if(con!=null)try{

con.close();

}catch(SQLException e) {//TODO Auto-generated catch block

e.printStackTrace();

}

}public static voidclose(Statement state, Connection conn) {if(state!=