?? visitdata.java
字號(hào):
// VisitData
package classFile;
import javax.swing.*;
import java.sql.*;
class VisitData
{
public Connection con = null;
public ResultSet result;
public Statement stmt;
public PreparedStatement pre = null;
private String url = new String("jdbc:odbc:data");
private String driver = new String("sun.jdbc.odbc.JdbcOdbcDriver");
public VisitData()
{
try
{
Class.forName(driver);
con = DriverManager.getConnection(url,"lp", "lp");
}
catch(Exception e)
{
JOptionPane.showMessageDialog(null, "數(shù)據(jù)庫(kù)連接失敗!!");
e.printStackTrace();
}
}
public void DBLind(String sql) throws Exception
{
pre = con.prepareStatement(sql);
}
public void query(String sql) throws Exception
{
stmt = con.createStatement();
result = stmt.executeQuery(sql);
}
public void closeDB() throws Exception
{
con.close();
stmt.close();
result.close();
pre.close();
}
}
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -