?? statistic.java
字號:
package com.javaBean;
import java.sql.*;
public class statistic {
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
public statistic() {
try {
Class.forName("com.mysql.jdbc.Driver");
}
catch(java.lang.ClassNotFoundException e) {
System.err.println("mystatistic(): " + e.getMessage());
}
}
public ResultSet executeQuery(String sql) {
rs = null;
try {
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/managedb?user=root&password=123123&useUnicode=true");
stmt = con.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println("statistic.executeQuery: " + ex.getMessage());
}
return rs;
}
public void executeUpdate(String sql) {
try {
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/managedb?user=root&password=123123&useUnicode=true");
Statement stmt = con.createStatement();
stmt.executeUpdate(sql);
}
catch(SQLException ex) {
System.err.println("statistic.executeUpdate: " + ex.getMessage());
}
}
public void close()
{
try
{
con.close();
stmt.close();
}
catch (SQLException sqle)
{
System.out.println("sqle=" + sqle);
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -