package net.Model;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import net.Conn.Conn;
import net.View.UserVo;
public class UserModel {
Conn con;
public void insert(UserVo Vo) {// 用户添加
con = new Conn();
PreparedStatement ps = null;
System.out.println(Vo.getUsername());
System.out.println(Vo.getPassword());
System.out.println(Vo.getYzm());
String sql = "insert into inserUser values(?,?,?)";
try {
ps = con.getcon().prepareStatement(sql);
ps.setString(1, Vo.getUsername());
ps.setString(2, Vo.getPassword());
ps.setString(3, Vo.getYzm());
ps.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public ArrayList selectUser() {// 用户查询
con = new Conn();
ArrayList list = new ArrayList();
Statement stm = null;
ResultSet rs = null;
UserVo vo = null;
String sql = "select * from inserUser";
try {
stm = con.getcon().createStatement();
rs = stm.executeQuery(sql);
while (rs.next()) {
vo = new UserVo();
vo.setUserid(rs.getInt(1));
vo.setUsername(rs.getString(2));
vo.setPassword(rs.getString(3));
vo.setYzm(rs.getString(4));
list.add(vo);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}
public void deletUser(int id) {// 用户删除
con = new Conn();
String sql = "delete from inserUser where userid=" + id;
Statement stmt = null;
try {
stmt = con.getcon().createStatement();
stmt.executeUpdate(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}