基于Java+JSP SQL教材管理系统(毕业设计作品)毕业设计实现+源码.zip

package bean; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.*; import util.*; public class UserLoginBean { Connection conn = null; Statement st = null; ResultSet rs = null; ArrayList al = new ArrayList(); public int login(String name,String pwd){ int temp = 0; DBConn dbo=new DBConn(); dbo.open(); try { rs = dbo.executeQuery("select * from admin where name='"+name+"'"); if(rs.next()){ String id = rs.getString("id"); String tname = rs.getString("name"); String tpwd = rs.getString("pwd"); if(pwd.equals(tpwd)){ temp = 1; al.add(id); al.add(tname); al.add(tpwd); }else{ temp = 2; } }else{ temp = 3; } } catch (SQLException e) { e.printStackTrace(); } finally{ dbo.close(); } return temp; } public List getMygl(){ String sql="select hickey.name,mygl.* from hickey,mygl where mygl.ypmc=hickey.id order by hickey.id desc"; List list=new ArrayList(); Connection conn = null; Statement st = null; ResultSet rs = null; DBConn dbo=new DBConn(); dbo.open(); try { rs=dbo.executeQuery(sql); while(rs.next()){ List list2=new ArrayList(); list2.add(rs.getString(1)); list2.add(rs.getString(2)); list2.add(rs.getString(3)); list2.add(rs.getString(4)); list2.add(rs.getString(5)); list2.add(rs.getString(6)); list2.add(rs.getString(7)); list2.add(rs.getString(8)); list2.add(rs.getString(9)); list2.add(rs.getString(10)); list2.add(rs.getString(11)); list2.add(rs.getString(12)); list.add(list2); } return list; } catch (SQLException e) { e.printStackTrace(); return list; } finally{ dbo.close(); } } public List getMygl(String id){ String sql="select hickey.name,mygl.* from hickey,mygl where mygl.ypmc=hickey.id and mygl.id ='"+id+"'"; List list=new ArrayList(); Connection conn = null; Statement st = null; ResultSet rs = null; DBConn dbo=new DBConn(); dbo.open(); try { rs=dbo.executeQuery(sql); rs.next(); list.add(rs.getString(1)); list.add(rs.getString(2)); list.add(rs.getString(3)); list.add(rs.getString(4)); list.add(rs.getString(5)); list.add(rs.getString(6)); list.add(rs.getString(7)); list.add(rs.getString(8)); list.add(rs.getString(9)); list.add(rs.getString(10)); list.add(rs.getString(11)); list.add(rs.getString(12)); return list; } catch (SQLException e) { e.printStackTrace(); return list; } finally{ dbo.close(); } } public ArrayList getArrayLst(){ return al; } }