?? dbconnect.java
字號:
package data;
import java.sql.*;
public class DBConnect {
String driver = "com.mysql.jdbc.Driver";
String url= "jdbc:mysql://localhost:3306/mysql";
String username= "root";
String password= "123";
Connection conn;
ResultSet rs;
public DBConnect()
{
try
{
Class.forName(driver);//創建數據庫連接驅動
}
catch(ClassNotFoundException e)
{
System.out.println( "jdbc: "+ e.getMessage());
}
}
public void executeUpdate(String sql)throws Exception
{
//sql=new String(sql.getBytes( "BG2312 "), "ISO8859_1 ");
try
{
conn=DriverManager.getConnection(url,username,password);
Statement stmt=conn.createStatement();
stmt.executeUpdate(sql);
//stmt.close();
//conn.close();
}
catch(SQLException eX)
{
System.out.println( "jdbc: "+ eX.getMessage());
}
}
public ResultSet executeQurey(String sql)throws Exception
{
rs=null;
//sql=new String(sql.getBytes( "BG2312 "), "ISO8859_1 ");
try
{
conn=DriverManager.getConnection(url,username,password);
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
//stmt.close();
//conn.close();
}
catch(SQLException eX)
{
System.out.println( "jdbc: "+ eX.getMessage());
}
return rs;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -