?? dbconn.java~2~
字號:
package check;import java.sql.*;public class dbconn { private String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";//加載驅(qū)動程序 private String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydata";//設(shè)置數(shù)據(jù)庫連接串 private String user = "sa";//數(shù)據(jù)庫登錄用戶名 private String password = "mc";//數(shù)據(jù)庫登錄密碼 public void setDriverName(String newDriverName) { driverName = newDriverName; } public String getDriverName() { return driverName; } public void setUrl(String newUrl) { url = newUrl; } public String getUrl() { return url; } public void setUser(String newUser) { user = newUser; } public String getUser() { return user; } public void setPassword(String newPassword) { password = newPassword; } public String getPassword() { return password; } public Connection getConnection() { try { Class.forName(driverName); return DriverManager.getConnection(url, user, password); } catch (Exception e) { e.printStackTrace(); return null; } } public static void main(String[] args) { try{ dbconn dc = new dbconn(); Connection conn = dc.getConnection(); Statement stmt=conn.createStatement(); ResultSet rs=stmt.executeQuery("select * from My_BookAdminUser"); while(rs.next()){ System.out.print("名稱: "+rs.getString(1)); System.out.print("\tpassword: "+rs.getString(2)); System.out.println(); } }catch(Exception e){ e.printStackTrace(); } }}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -