?? dbconnect.java~1~
字號:
package studentmanage;import java.sql.*;/** * <p>Title: </p> * <p>Description: </p> * <p>Copyright: Copyright (c) 2005</p> * <p>Company: </p> * @author not attributable * @version 1.0 */public class DbConnect { public static void loadClass(){ try{ Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); }catch(ClassNotFoundException e1){ System.out.println("加載JDBC數(shù)據(jù)庫驅動程序出錯"); } } public static Connection makeConnect(String ip,String dbname,String user,String pwd){ String url="jdbc:microsoft:sqlserver://"+ip+":1433;DatabaseName="+dbname; System.out.println(url); Connection con=null; try{ con=DriverManager.getConnection(url,user,pwd); }catch(SQLException e2){ System.out.println("建立Connection對象出錯"); } return con; } public static Statement makeStatement(Connection con){ Statement stmt=null; try{ stmt=con.createStatement(); }catch(SQLException e3){ System.out.println("建立Statement對象出錯"); } return stmt; } public static ResultSet makeResultSet(Statement stmt,String sql){ ResultSet rs=null; try{ rs = stmt.executeQuery(sql); }catch(SQLException e2){ System.out.println("讀取數(shù)據(jù)出錯"); } return rs; } public static void close(ResultSet rs){ try{ rs.close(); }catch(SQLException e4){ System.out.println("關閉ResultSet對象出錯"); } } public static void close(Statement stmt){ try{ stmt.close(); }catch(SQLException e4){ System.out.println("關閉Statement對象出錯"); } } public static void close(Connection con){ try{ con.close(); }catch(SQLException e4){ System.out.println("Connection對象出錯"); } }}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -