?? dbconn.java
字號:
package cr;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DBConn {
private Connection conn;
private Statement stmt;
private ResultSet rs;
Connection getConn(){
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection("jdbc:odbc:sun");
return conn;
} catch (ClassNotFoundException ex) {
return null;
} catch (SQLException ex) {
/** @todo Handle this exception */
return null;
}
}
public ResultSet execQuery(String strSQL){
Connection conn=getConn();
try {
stmt = conn.createStatement();
rs = stmt.executeQuery(strSQL);
return rs;
} catch (SQLException ex) {
return null;
}
}
public int execOther(String strSQL){
int count = 0;
Connection conn=getConn();
try {
stmt = conn.createStatement();
count = stmt.executeUpdate(strSQL);
return count;
} catch (SQLException ex) {
return -1;
}
}
public static void main(String[] args) {
// TODO Auto-generated method stub
DBConn dbconn = new DBConn();
Connection conn=dbconn.getConn();
if(conn == null){
System.out.println("Connection is error");
}else{
System.out.println("connection is OK");
//在這里創建frame,連接到你想連的窗口界面。
new LoginWindow();
}
ResultSet rs = dbconn.execQuery("select * from login");
try {
while(rs.next()){
System.out.println(rs.getInt(1));
System.out.println(rs.getString(2));
System.out.println(rs.getString(3));
System.out.println(rs.getString(4));
System.out.println(rs.getShort(5));
System.out.println(rs.getString(6));
System.out.println(rs.getString(7));
System.out.println(rs.getString(8));
System.out.println(rs.getString(9));
System.out.println(rs.getString(10));
System.out.println(rs.getInt(11));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -