|
import java.sql.*; ResultSet rs=null; String classname=""; Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=basename"; String user="sa"; String password=""; Connection conn= DriverManager.getConnection(url,user,password); Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); String sql="select * from class"; rs=stmt.executeQuery(sql); while(rs.next()) { classname=rs.getString("classname"); classname = new String(classname.getBytes("ISO-8859-1"),"gb2312"); System.out.println(classname); } --------------------------------------------------------------- jdbc驅(qū)動(dòng)設(shè)置（非jbuilder的運(yùn)行環(huán)境下，比如cmd環(huán)境）： 下載一個(gè)驅(qū)動(dòng)，安裝后將驅(qū)動(dòng)文件的絕對路徑放入classpath環(huán)境變量里面去，最好將驅(qū)動(dòng)就 安裝到j(luò)dk的lib目錄里面算了。 這方面設(shè)置若有問題參考： http://www.csdn.net/expert/topic/750/750375.xml?temp=.4715387 JBuilder連接數(shù)據(jù)庫的jdbc驅(qū)動(dòng)設(shè)置: 1.在tools->configre libraries->new->鍵入name－>add->選擇驅(qū)動(dòng)文件。不妨設(shè)置在User Home下面 2.tools->enterprise setup->database Drier－>add->選擇剛才新建的 3.tools->database pilot->file->new->鍵入：url和Driver 4.雙擊－>輸入數(shù)據(jù)庫的用戶名和密碼 可運(yùn)行代碼實(shí)例： import java.sql.*; public class Test { public static void main(String[] args) { try { String address = "jdbc:microsoft:sqlserver://192.168.0.24:1433"; //驅(qū)動(dòng)類型＋目標(biāo)數(shù)據(jù)庫ip＋數(shù)據(jù)庫端口 String user="sa";//數(shù)據(jù)庫用戶密碼 String passwd="";//口令 String database = "TESTDB";//目標(biāo)數(shù)據(jù)庫 Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");//驅(qū)動(dòng)申明 Connection con = DriverManager.getConnection(address,user,passwd);//建立鏈接 con.setCatalog(database);//確定目標(biāo)數(shù)據(jù)庫 Statement smt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); //建立描述，設(shè)定結(jié)果集支持滾動(dòng)光標(biāo)且敏感，不可編輯 String selCode = "SELECT userId,userName FROM UserTable";//查詢語句 ResultSet rs = smt.executeQuery(selCode);//結(jié)果集 if(rs.last()) {//從第一條往后依次取結(jié)果集中的記錄 String userId = rs.getString(1);//等同rs.getString("userId")，即第一個(gè)字段 數(shù)據(jù) String userName = rs.getString(2);//同上，第二個(gè)字段，全部取其為String類型 //若是中文字段，一般需要轉(zhuǎn)碼 //userName = new String(userName.getBytes("ISO-8859-1"),"gb2312"); System.out.println(userId+":"+userName);//輸出此條記錄的查詢結(jié)果 } rs.close();//釋放資源 smt.close(); con.close(); } catch(Exception e) { System.out.println(e);//捕捉異常 } } } --------------------------------------------------------------- import java.sql.*; public class opendb { String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; String sConnStr = "jdbc:odbc:IkUtil"; Connection conn=null; ResultSet rs = null; public opendb() { try { Class.forName(sDBDriver); } catch(java.lang.ClassNotFoundException e) { System.err.println("opendb(): " + e.getMessage()); } } public ResultSet executeQuery(String sql) { rs = null; try { conn = DriverManager.getConnection(sConnStr); Statement stmt = conn.createStatement(); rs = stmt.executeQuery(sql); } catch(Exception ex) { System.err.println("aq.executeQuery: " + ex.getMessage()); } return rs; } } |
|
|
