JAVA web寝室管理代码

package com; import java.sql.*; import java.util.ArrayList; public class AddSql { public static boolean addStudent(String A, String B, String C, String D, String E, String F, String G, String H, String I) throws SQLException { Connection conn = C3P0_Utils.getConnection(); String sql = "insert into stu (student,number,teacher,classes,roomname,floorname,room,state,roomstate) VALUES(?,?,?,?,?,?,?,?,?)"; PreparedStatement stm = null; try { stm = conn.prepareStatement(sql); stm.setString(1, A); stm.setString(2, B); stm.setString(3, C); stm.setString(4, D); stm.setString(5, E); stm.setString(6, F); stm.setString(7, G); stm.setString(8, H); stm.setString(9, I); boolean a = false; int rs = stm.executeUpdate(); return rs == 1; } catch (SQLException var10) { return false; } } public static boolean ChangeStudent(String A, String B, String C, String D, String E, String F, String G, String H, String I) throws SQLException { Connection conn = C3P0_Utils.getConnection(); String AA="'"+A+"'"; String sql = "update stu set number=?,teacher=?,classes=?,roomname=?,floorname=?,room=?,state=?,roomstate=? where student="+AA; PreparedStatement stm = null; try { stm = conn.prepareStatement(sql); stm.setString(1, B); stm.setString(2, C); stm.setString(3, D); stm.setString(4, E); stm.setString(5, F); stm.setString(6, G); stm.setString(7, H); stm.setString(8, I); boolean a = false; int rs = stm.executeUpdate(); return rs == 1; } catch (SQLException var10) { return false; } } public static boolean deleteStudent(String A) throws SQLException { Connection conn = C3P0_Utils.getConnection(); String sql = "DELETE from stu where student=?"; PreparedStatement stm = null; try { stm = conn.prepareStatement(sql); stm.setString(1,A); boolean a = false; int rs = stm.executeUpdate(); return rs == 1; } catch (SQLException var10) { return false; } } public static ArrayList getLikeList() throws SQLException { ArrayList list = new ArrayList(); Connection conn = C3P0_Utils.getConnection(); Statement st = null; ResultSet rs = null; try { //获取数据库连接 conn = C3P0_Utils.getConnection(); String sql = "select * from stu"; st = (Statement) conn.createStatement(); rs = st.executeQuery(sql); System.out.println("正在查询"); while (rs.next()) { Student stu=new Student(); stu.setStudent(rs.getString("student")); stu.setNumber(rs.getString("number")); stu.setTeacher(rs.getString("teacher")); stu.setClasses(rs.getString("classes")); stu.setRoomname(rs.getString("roomname")); stu.setFloorname(rs.getString("floorname")); stu.setRoom(rs.getString("room")); stu.setState(rs.getString("state")); stu.setRoomstate(rs.getString("roomstate")); list.add(stu); } } catch (Exception e) { e.printStackTrace(); } finally { //释放资源 C3P0_Utils.release(conn, st, rs); } return list; } public static boolean addAccount(String A, String B) throws SQLException { Connection conn = C3P0_Utils.getConnection(); String sql = "insert into account (ID,PASSWORD) VALUES(?,?)"; PreparedStatement stm = null; try { stm = conn.prepareStatement(sql); stm.setString(1, A); stm.setString(2, B); boolean a = false; int rs = stm.executeUpdate(); return rs == 1; } catch (SQLException var10) { return false; } } public static ArrayList getLikeList1(String A) throws SQLException { String AA="'"+A+"'"; ArrayList list = new ArrayList(); Connection conn = C3P0_Utils.getConnection(); Statement st = null; ResultSet rs = null; try { //获取数据库连接 conn = C3P0_Utils.getConnection(); String sql = "select * from stu where teacher="+AA; st = (Statement) conn.createStatement(); rs = st.executeQuery(sql); System.out.println("正在查询"); while (rs.next()) { Student stu=new Student(); stu.setStudent(rs.getString("student")); stu.setNumber(rs.getString("number")); stu.setTeacher(rs.getString("teacher")); stu.setClasses(rs.getString("classes")); stu.setRoomname(rs.getString("roomname")); stu.setFloorname(rs.getString("floorname")); stu.setRoom(rs.getString("room")); stu.setState(rs.getString("state")); stu.setRoomstate(rs.getString("roomstate")); list.add(stu); } } catch (Exception e) { e.printStackTrace(); } finally { //释放资源 C3P0_Utils.release(conn, st, rs); } return list; } }