HNU编程新技术实务实验二——HTML以及J2EE简单编程

package lab2_page; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.*; public class PersonCmd { private Integer judge_person; private Integer judge_user=0; private Integer judge_delete; public void Createtable(Function f) throws Exception//建表 { String sql = "create table person" + "(" + "username varchar(10) not null," + "name varchar(20) not null primary key," + "age int default 20," + "teleno char(11) default '22222222222'" + ")"; f.getpre(sql).executeUpdate(); } public Integer getjudge_user() { return judge_user; } public Integer getjudge_person() { return judge_person; } public Integer getjudge_delete() { return judge_delete; } public void insert(Person p,Function f) throws Exception//插入person { String sql = "insert into person(username,name,age,teleno) values(?, ?, ?, ?)"; String p1=p.getusername(); String p2=p.getname(); String p3=p.getage(); String p4=p.getteleno(); PreparedStatement pre=f.getpre(sql); pre.setString(1, p1); pre.setString(2, p2); pre.setString(3, p3); pre.setString(4, p4); pre.executeUpdate(); } public void delete(String s,Function f)throws Exception//删除person表中s打头的username { String sql1="select * from person where username=?"; PreparedStatement pre=f.getpre(sql1); pre.setString(1, s); ResultSet result=pre.executeQuery(); if(!result.next()) { judge_delete=1; } else { String sql="delete from person where username like ?"; pre=f.getpre(sql); pre.setString(1, s); pre.executeUpdate(); judge_delete=2; } } public List<Person> Query(Function f) throws Exception//查整个表 { String sql = "select * from person"; ResultSet result=f.getpre(sql).executeQuery(); List<Person> pl=new ArrayList<>(); while(result.next()) { String p1=result.getString("username"); String p2=result.getString("name"); String p3=result.getString("age"); String p4=result.getString("teleno"); Person pers=new Person(p1,p2,p3,p4); pl.add(pers); } return pl; } public void addormodify(Person p,Function f)throws Exception//用于添加或修改person表中的数据 { String sql1="select * from person where username=?"; PreparedStatement pre=f.getpre(sql1); String pp1=p.getusername(); pre.setString(1,pp1); ResultSet result=pre.executeQuery(); if(result.next()) { String sql2="update person set name=?,age=?,teleno=? where username=?"; String p1=p.getname(); String p2=p.getage(); String p3=p.getteleno(); String p4=p.getusername(); pre=f.getpre(sql2); pre.setString(1, p1); pre.setString(2, p2); pre.setString(3, p3); pre.setString(4, p4); pre.executeUpdate(); judge_person=1; } else { String sql2="insert into person(username,name,age,teleno) values(?, ?, ?, ?)"; String p1=p.getusername(); String p2=p.getname(); String p3=p.getage(); String p4=p.getteleno(); pre=f.getpre(sql2); pre.setString(1, p1); pre.setString(2, p2); pre.setString(3, p3); pre.setString(4, p4); pre.executeUpdate(); judge_person=2; } String sql3="select * from users where username=?";//查看users表中有无该username pre=f.getpre(sql3); pre.setString(1,pp1); result=pre.executeQuery(); if(!result.next()) { String sql4="insert into users(username,pass) values(?,?)"; String p1=p.getusername(); pre=f.getpre(sql4); pre.setString(1, p1); pre.setString(2, "888888"); pre.executeUpdate(); judge_user=1; } } public void droptable(Function f)throws Exception { String sql="drop table person"; f.getpre(sql).executeUpdate(); } }