?? jdbcodbc_con.java
字號:
package sts;
import java.sql.*;
public class JdbcOdbc_Con
{
String dbDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String strCon = "jdbc:odbc:sts";
Connection con = null;
ResultSet rs = null;
Statement stmt = null;
public JdbcOdbc_Con()
{
try
{
Class.forName(dbDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("數據庫驅動程序加載失敗,異常為:" + e.getMessage());
}
finally
{
System.out.println("驅動程序加載成功");
}
}
public ResultSet executeQuery(String strSQL)
{
rs = null;
try
{
con = DriverManager.getConnection(strCon);
Statement stmt = con.createStatement();
rs = stmt.executeQuery(strSQL);
}
catch(SQLException ex)
{
System.err.println("連接數據庫失敗了,異常為:" +ex.getMessage());
}
finally
{
System.out.println("數據庫連接成功");
}
return rs;
}
public void executeUpdate(String strSQL)
{
try
{
con = DriverManager.getConnection(strCon);
stmt = con.createStatement();
stmt.executeQuery(strSQL);
}
catch(SQLException ex)
{
System.err.println("連接數據庫失敗了,異常為:" +ex.getMessage());
}
}
public String ex_chinese(String str)
{
if(str==null)
{
str ="" ;
}
else
{
try
{
str = new String(str.getBytes("iso-8859-1"),"gb2312") ;
}
catch (Exception ex)
{
System.err.println("異常為:" +ex.getMessage());
}
}
return str ;
}
public String gettime()
{
String datestr = "" ;
try
{
java.text.DateFormat df = new java.text.SimpleDateFormat("yyyy年MM月dd日 HH點ss分") ;
java.util.Date date = new java.util.Date() ;
datestr = df.format(new java.util.Date()) ;
}
catch (Exception ex)
{
System.err.println("異常為:" +ex.getMessage());
}
return datestr ;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -