?? dbconn.java
字號(hào):
package db;
import java.sql.*;
public class dbConn
{
String sDBDriver ="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String sConnStr = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=YouBangDB";
String user = "sa";
String password = "admin";
Connection conn = null;
ResultSet rs = null;
int result;
//
public dbConn()
{
try
{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println(e.getMessage());
}
}
//詢侄渭詢
public ResultSet executeQuery(String sql)
{
try
{
conn = DriverManager.getConnection(sConnStr,user,password);
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println(ex.getMessage());
}
return rs;
}
//蕕姆
/*public int executeUpdate(String sql)
{
try
{
conn = DriverManager.getConnection(sConnStr,user,password);
Statement stmt = conn.createStatement();
result = stmt.executeUpdate(sql);
}
catch(SQLException ex)
{
System.err.println(ex.getMessage());
}
return result;
}*/
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -