設(shè)備管理系統(tǒng)源代碼(共6頁(yè))

1、精選優(yōu)質(zhì)文檔-傾情為你奉上package com.DB;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class DBManager private final static String driver = "com.microsoft.jdbc.sqlserver.SQLSe

2、rverDriver"private final static String url = "jdbc:microsoft:sqlserver:/127.0.0.1:1433;DataBaseName=bbsDB"private Connection conn;private Statement st;private ResultSet rs;/* * 創(chuàng)建連接 * return */public Connection getConnection()if(conn=null)try Class.forName(driver);conn = DriverManager

3、.getConnection(url,"sa","root"); catch (ClassNotFoundException e) / TODO Auto-generated catch blocke.printStackTrace(); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();return conn;/* * 創(chuàng)建statement */public Statement getStatement()if(st=null)try st = co

4、nn.createStatement(); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();return st;/* * 執(zhí)行更新操作 */public int update(String sql)System.out.println(">>>>>>>>="+sql);getConnection();int rows=0;st=getStatement();try rows = st.executeUpdate(sql);

5、catch (SQLException e) e.printStackTrace();finallycloseAll();return rows;/* * 使用預(yù)處理 */public int update(String sql,String data)System.out.println(">>>>="+sql);getConnection();try int index = 0;PreparedStatement pst = conn.prepareStatement(sql);for (int i = 0; i < data.length

6、; i+) pst.setString(+index, datai);return pst.executeUpdate(); catch (SQLException e) e.printStackTrace();finallycloseAll();return 0;/* * 執(zhí)行查詢操作 */public ResultSet getQuery(String sql)System.out.println(">>>>>>>>="+sql);getConnection();st = getStatement();try rs = st.executeQuery(sql); catch (SQLException e) e.printStackTrace();return rs;/* * 執(zhí)行關(guān)閉 */public void closeAll()if(rs!=null)try rs.close();rs = null; catch (SQLException e) e.printStackTrace();if(st!=null)try st.close();st = null; catch (SQLException e) e.print