DBUtil_JAVA_编程开发_程序员俱乐部

?public static Connection getConnection(){
???? Connection con=null;
???? try{
???????? con=DriverManager.getConnection(
?????????? "jdbc:mysql://localhost:3306/department","root","root"?
?????? );
???? }catch(Exception e){
???????? e.printStackTrace();
???? }
???? return con;
?}

?public static void release(ResultSet rs,Statement stmt,Connection con){
???? if(rs!=null){
??????? try{rs.close();}catch(SQLException e){e.printStackTrace();};
???? }
???? if(stmt!=null){
??????? try{stmt.close();}catch(SQLException e){e.printStackTrace();};
???? }
???? if(con!= null){
??????? try{con.close();}catch(SQLException e){e.printStackTrace();};
???? }
?}

?public boolean save(Department dept){
??Connection con = JDBC.getConnection();
??String sql = "insert into department values(?,?,?)";
??try {
???PreparedStatement pstmt = con.prepareStatement(sql);
???pstmt.setString(1, dept.getId());
???pstmt.setString(2, dept.getName());
???pstmt.setInt(3, dept.getNumber());
???pstmt.execute();
???System.out.println("保存成功");
???return true;
??} catch (SQLException e) {
???// TODO Auto-generated catch block
???e.printStackTrace();
???System.out.println("保存失败");
???return false;
??}
?}
?
?public List<Department> getAllDept(String flag,String category){
??String sql = getDeptSql(flag,category);
??try {
???PreparedStatement pstmt = JDBC.getConnection().prepareStatement(sql);
???ResultSet rs = pstmt.executeQuery();
???List<Department> deptList = new ArrayList<Department>();
???while(rs.next()){
????Department dept = new Department();
????dept.setId(rs.getString(1));
????dept.setName(rs.getString(2));
????dept.setNumber(rs.getInt(3));
????deptList.add(dept);
???}
???System.out.println("查询成功");
???return deptList;
??} catch (Exception e) {
???e.printStackTrace();
???System.out.println("查询失败");
???return null;
??}
?}
?public String getDeptSql(String flag,String category){
??if(flag.equals("up")){
???if(category.equals("number")){
????return "select * from department order by number";
???}else{
????return "select * from department order by name";
???}
??}else{
???if(category.equals("number")){
????return "select * from department order by number desc";
???}else{
????return "select * from department order by name desc";
???}
??}
?}
?public static void main(String[] args) {
//??JDBC db = new JDBC();
?}
?
?

}