?? dbconn.java
字號:
package dbConn;
import java.sql.*;
import java.io.*;
import java.util.*;
import javax.naming.*;
public class dbConn{
Connection conn = null;
CallableStatement stmtpro = null;
Statement stmt=null;
ResultSet rs = null;
public dbConn(){
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=td;user=td;password=td");
} catch(java.lang.SecurityException se) {
throw se;
} catch(java.lang.Exception e) {
e.printStackTrace();
}
}
//數據處理
public ResultSet executeQuery(String sql){
stmt=null;
rs = null;
try {
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
} catch(SQLException ex){
System.err.println("sql_data.executeUpdate:"+ex.getMessage());
//顯示數據庫連接錯誤或者查詢錯誤
}
return rs;
}
//數據更新
public int executeUpdate(String sql){
stmt=null;
int number = 0;
try {
stmt=conn.createStatement();
stmt.executeUpdate(sql);
if (conn==null) { return -1; }
if (stmt == null) { return -1; }
}
catch(SQLException ex){
System.err.println("sql_data.executeUpdate:"+ex.getMessage());
return -1;
}
return number;
}
public String executeProcedure(String BHMC){
stmtpro = null;
String BH=null;
String sql=null;
sql="{ call P_NB_BH(?,?)}";
try {
stmtpro=conn.prepareCall(sql);
stmtpro.setString(1,BHMC);
stmtpro.registerOutParameter(2,Types.CHAR);
stmtpro.executeUpdate();
BH = stmtpro.getString(2);
} catch(SQLException ex){
System.err.println("sql_data.executeUpdate:"+ex.getMessage());
//顯示數據庫連接錯誤或者查詢錯誤
}
return BH;
}
//關閉數據源,斷開連接
public boolean close(){
try{
if(this.rs!=null){
this.rs.close();
}
if(stmt!=null){
this.stmt.close();
}
if(stmtpro!=null){
this.stmtpro.close();
}
if(conn!=null){
this.conn.close();
}
return true;
}catch(Exception err){
return false;
}
}
public String show(String str){
String str1="";
if(str.compareTo("1")==0){
str1="\u221A";
}else{
str1=" ";
}
return str1;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -