?? sql.java
字號:
package Tools;import java.sql.*;public class sql{ String dbDriver = "com.mysql.jdbc.Driver"; String ConnStr = "jdbc:mysql://localhost:3306/Bank"; Connection Conn = null; ResultSet Rst = null; public sql(){ try{ Class.forName("com.mysql.jdbc.Driver"); }catch(java.lang.ClassNotFoundException e){ System.err.print(e.getMessage()); } } public ResultSet sqlQuery(String cmdText){ Rst = null; try{ Conn = DriverManager.getConnection(ConnStr, "root", "wb"); Statement stmt = Conn.createStatement(); try{ Rst = stmt.executeQuery(cmdText); }catch(java.sql.SQLException e){ System.err.println("falier1"+e); } //Conn.close(); }catch(java.sql.SQLException e){ System.err.println("failer2"+e); } return Rst; } public void sqlUpdate(String cmdText){ try{ Conn = DriverManager.getConnection(ConnStr, "root", "wb"); Statement stmt = Conn.createStatement(); stmt.executeUpdate(cmdText); //Conn.close(); }catch(java.sql.SQLException e){ System.err.println(e); } } }
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -