jsp实现简单的学生管理信息系统的类

连接类的实现

<span style="font-size:18px;">package one.java.Connection;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;public class GetConnection { static Connection cc=null; static String  url="jdbc:mysql:///jkxy?useUnicode=true&characterEncoding=utf-8"; static String  name="root"; static String  password="123456";public  static Connection getconnection(){try {Class.forName("com.mysql.jdbc.Driver");} catch (ClassNotFoundException e) {e.printStackTrace();} try {cc= DriverManager.getConnection(url,name,password);return cc;} catch (SQLException e) {e.printStackTrace();return null;}}}</span>

管理员类的实现

<span style="font-size:18px;">package one.java.dom;public class Admin {  private  String username=null;  private  String password=null;  public String getUsername() {return username;}public void setUsername(String username) {this.username = username;}public String getPassword() {return password;}public void setPassword(String password) {this.password = password;}}</span>

登陆类的实现

<span style="font-size:18px;">package one.java.dom;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import one.java.Connection.GetConnection;import one.java.dom.*;public class UserService {private static Connection conn;private PreparedStatement pstmt;    public  UserService(){    conn = GetConnection.getconnection();        }public  boolean loginAdmin(Admin admin){try {pstmt=conn.prepareStatement("select * from tb_admin where username=? and password=?");pstmt.setString(1,admin.getUsername());pstmt.setString(2,admin.getPassword());ResultSet rs=pstmt.executeQuery();if(rs.next()) return true;elsereturn false;} catch (SQLException e) {e.printStackTrace();return false;}}}</span>

学生增删该查的实现

<span style="font-size:18px;">package student.java.info;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.util.ArrayList;import java.util.List;import one.java.Connection.GetConnection;public class StudentService {private Connection conn;private PreparedStatement pstmt;public StudentService(){conn = GetConnection.getconnection();}public boolean addStu(StuInfo stu) {try {pstmt = conn.prepareStatement("insert into tb_student"+ "(nicheng,truename,sex,birthday,zy,kc,xq,br) "+ "values(?,?,?,?,?,?,?,?)");pstmt.setString(1, stu.getNicheng());pstmt.setString(2, stu.getTruename());pstmt.setByte(3, stu.getXb());pstmt.setString(4, stu.getCsrq());pstmt.setString(5, stu.getZy());pstmt.setString(6, stu.getKcs());pstmt.setString(7, stu.getXqs());pstmt.setString(8, stu.getBz());pstmt.executeUpdate();return true;} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();return false;}}public List<StuInfo> queryAllStu() {List<StuInfo> stus = new ArrayList<StuInfo>();try {pstmt = conn.prepareStatement("select * from tb_student");ResultSet rs = pstmt.executeQuery();while (rs.next()) {StuInfo stu = new StuInfo();stu.setId(rs.getInt(1));stu.setNicheng(rs.getString(2));stu.setTruename(rs.getString(3));stu.setXb(rs.getByte(4));if (rs.getDate(5) != null)stu.setCsrq(rs.getDate(5).toString());stu.setZy(rs.getString(6));if (rs.getString(7) != null)stu.setKc(rs.getString(7).split("&"));if (rs.getString(8) != null)stu.setXq(rs.getString(8).split("&"));stu.setBz(rs.getString(9));stus.add(stu);}return stus;} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();return null;}}public StuInfo queryStubyID(int id) {// List stus = new ArrayList();try {pstmt = conn.prepareStatement("select * from tb_student where id=?");pstmt.setInt(1, id);ResultSet rs = pstmt.executeQuery();if (rs.next()) {StuInfo stu = new StuInfo();stu.setId(rs.getInt(1));stu.setNicheng(rs.getString(2));stu.setTruename(rs.getString(3));stu.setXb(rs.getByte(4));if (rs.getDate(5) != null)stu.setCsrq(rs.getDate(5).toString());stu.setZy(rs.getString(6));if (rs.getString(7) != null)stu.setKc(rs.getString(7).split("&"));if (rs.getString(8) != null)stu.setXq(rs.getString(8).split("&"));stu.setBz(rs.getString(9));// stus.add(stu);return stu;}return null;} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();return null;}}public boolean updateStu(StuInfo stu) {try {pstmt = conn.prepareStatement("update  tb_student set nicheng=? , truename=? , sex=? ,birthday=? ,"+ " zy=? ,kc=? , xq=?, br=?   where id=?");pstmt.setString(1, stu.getNicheng());pstmt.setString(2, stu.getTruename());pstmt.setByte(3, stu.getXb());pstmt.setString(4, stu.getCsrq());pstmt.setString(5, stu.getZy());pstmt.setString(6, stu.getKcs());pstmt.setString(7, stu.getXqs());pstmt.setString(8, stu.getBz());pstmt.setInt(9, stu.getId());pstmt.executeUpdate();return true;} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();return false;}}public Boolean deleteStu(int id) {try {pstmt = conn.prepareStatement("delete from  tb_student where id=?");pstmt.setInt(1, id);pstmt.executeUpdate();return true;} catch (Exception e) {e.getStackTrace();return false;}}}</span>

学生类的实现

<span style="font-size:18px;">package student.java.info;public class StuInfo {private int id;private String nicheng;private String truename;private byte xb;private String csrq;private String zy;private String[] kc = { "" };private String kcs = "";private String[] xq = { "" };private String xqs = "";private String bz;public int getId() {return id;}public void setId(int id) {this.id = id;}public String getNicheng() {return nicheng;}public void setNicheng(String nicheng) {this.nicheng = nicheng;}public String getTruename() {return truename;}public void setTruename(String truename) {this.truename = truename;}public byte getXb() {return xb;}public void setXb(byte xb) {this.xb = xb;}public String getCsrq() {return csrq;}public void setCsrq(String csrq) {this.csrq = csrq;}public String getZy() {return zy;}public void setZy(String zy) {this.zy = zy;}public String[] getKc() {return kc;}public void setKc(String[] kc) {this.kc = kc;}public String getKcs() {if(kc!=null){kcs="";for(int i=0;i<kc.length;i++)kcs+=kc[i]+"&";}kcs=kcs.substring(0,kcs.length()-1);return kcs;}public void setKcs(String kcs) {this.kcs = kcs;}public String[] getXq() {return xq;}public void setXq(String[] xq) {this.xq = xq;}public String getXqs() {if(xq!=null){xqs="";for(int i=0;i<xq.length;i++)xqs+=xq[i]+"&";}xqs=xqs.substring(0,xqs.length()-1);return xqs;}public void setXqs(String xqs) {this.xqs = xqs;}public String getBz() {return bz;}public void setBz(String bz) {this.bz = bz;}}</span>

不要忘了把需要的jdbcjar导入到 WEB-INF 的lib下面