SQL增删改查例子.docVIP

数据库连接与关闭类 Connection conn = null; PreparedStatement ps = null; ResultSet rs = null; String sql = ; import java.sql.Connection; import java.sql.DriverManager; import java.sql.*; import java.sql.SQLException; public class DBConnection { public static Connection getConnection()throws SQLException,IllegalAccessException{ Connection conn= null; try{ Class.forName(com.microsoft.jdbc.sqlserver.SQLServerDriver); String url =jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=cwgsj; String user = sa; String password = 123456; conn = DriverManager.getConnection(url, user, password); //System.out.println(数据库连接成功！); }catch(ClassNotFoundException e) {System.out.println(数据库连接失败：+e.getMessage());} catch (SQLException ex){ System.out.println(SQLException: + ex.getMessage()); System.out.println(SQLState: + ex.getSQLState()); } return conn; } public static void closeResource(ResultSet rs,Statement stmt,Connection conn){ if(rs!=null){ try { rs.close(); rs = null; } catch (SQLException e) { e.printStackTrace(); } } if(stmt!=null){ try { stmt.close(); stmt = null; } catch (SQLException e) { e.printStackTrace(); } } if(conn!=null){ try{ conn.close(); conn = null; }catch(SQLException ex) { System.err.println(ex.getMessage()); ex.printStackTrace(); System.out.println(-------------------数据库关闭失败！); } } } } 查询某单个字段 //根据采购单编号查找采购单是否属于大类型 public String findBigFlag(String buyid){ String bigflag = ; try { conn = DBConnection.getConnection(); String sql = select isbig from apply where buyid=?; ps = conn.prepareStatement(sql); ps.setString(1, buyid); rs = ps.executeQuery(); if(rs.next()){ bigflag = rs.getString(1); } } catch (Exception e) { System.out.println(查找该采购申请是否是大宗采购，ConPurchaseDAO); e.printStackTrace(); }finally{ DBConnection.closeResource(rs, ps, conn); } return bigflag; } 查询所有（对象集合） // 根据商品大类编号查找小类