?? jdbcconn.java~2~
字號:
package coursedesign;
import java.sql.*;
import java.io.*;
import java.lang.*;
public class Jdbcconn
{
private Connection db=null;
private Statement stmt=null;
ResultSet result=null;
public Jdbcconn(){}
public void OpenConn(String dsn,String uid,String pwd) throws Exception
{
try {
String strdsn="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName="+dsn;
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
db=DriverManager.getConnection(strdsn,uid,pwd);
}
catch (Exception e)
{
e.printStackTrace();
}
}
public ResultSet getResults(String sproc) throws Exception
{
Statement stmt=db.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet result=stmt.executeQuery(sproc);
result.last();
return result;
}
public void executeUpdate(String sql)
{
//stmt=null;
//result=null;
try
{
stmt=db.createStatement();
stmt.executeQuery(sql);
stmt.close();
stmt=null;
}
catch(SQLException ex)
{
System.err.println("aq.executeQuery: " + ex.getMessage());
}
}
public void closeStmt()
{
try
{
stmt.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
public void closeConn()
{
try
{
db.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -