?? dbsource.java
字號(hào):
package don;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DBSource
{
private Connection conn=null;
private Statement sta=null;
private ResultSet rs=null;
public DBSource()
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection("jdbc:odbc:mydb");
sta=conn.createStatement();
}
catch (ClassNotFoundException e)
{
e.printStackTrace();
}
catch (SQLException e)
{
e.printStackTrace();
}
}
//執(zhí)行查詢操作
public ResultSet executeQuery(String sql)
{
try
{
rs=sta.executeQuery(sql);
}
catch (SQLException e)
{
e.printStackTrace();
}
return rs;
}
//執(zhí)行插入修改操作
public boolean execute(String sql){
boolean b=false;
try
{
int i=sta.executeUpdate(sql);
if(i>0)
{
b=true;
}
}
catch (SQLException e)
{
e.printStackTrace();
}
return b;
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -