jsp实现简单的学生管理信息系统的类_public boolean login(admin admin) throws sqlexcept-优快云博客

本文链接：https://blog.youkuaiyun.com/u013372441/article/details/49512959

连接类的实现

<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;
			else
				return 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 block

			e.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 block
			e.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 block
			e.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 block
			e.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下面