?? connectdb.java
字號:
package yhgl;
import java.sql.*;
public class connectDB
{
String DBDriver = "oracle.jdbc.driver.OracleDriver";
String DBUrl = "jdbc:oracle:thin:@localhost:1521:ORACLE";
String DBUser = "jerry";
String DBPsw = "123456";
Connection conn = null;
PreparedStatement stmt = null;
public connectDB()
{
try
{
Class.forName(DBDriver);
conn = DriverManager.getConnection(DBUrl,DBUser,DBPsw);
}
catch (Exception e)
{
e.printStackTrace();
}
}
public ResultSet executeQuery(String sql) throws Exception
{
try
{
this.stmt = null;
this.stmt = conn.prepareStatement(sql);
return this.stmt.executeQuery();
}
catch (Exception e)
{
e.printStackTrace();
return null;
}
}
public int executeUpdate(String sql) throws Exception
{
try
{
this.stmt = null;
this.stmt = conn.prepareStatement(sql);
return this.stmt.executeUpdate();
}
catch (Exception e)
{
e.printStackTrace();
return 0;
}
}
public void closeDB()
{
try
{
conn.close();
stmt.close();
}
catch (Exception e)
{
e.printStackTrace();
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -