?? dbmanager.java
字號:
package achievo.dtree.dbmanager;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DBManager {
private Connection conn = null;
private ResultSet rst = null;
private Statement sta = null;
public Connection getConnection() {
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/dtree", "root", "root");
sta = conn.createStatement();
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}
public ResultSet getResultSet(String sql) {
this.getConnection();
try {
rst = sta.executeQuery(sql);
} catch (SQLException e) {
e.printStackTrace();
}
return rst;
}
public void close() {
try {
rst.close();
sta.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
// public static void main(String args[]) {
// DBManager db = new DBManager();
// ResultSet rs = null;
// try {
// rs = db.getResultSet("select * from student");
// System.out.println();
// while(rs.next()) {
// System.out.println(rs.getString("sname"));
// }
// } catch (SQLException e) {
// e.printStackTrace();
// }
// System.out.println();
//
// }
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -