資料庫連接配接與斷開:Connection conn=Jdbcutil.open();
Jdbcutil.close(conn);
package 資料庫.連接配接;
import java.sql.*;
public class Jdbcutil {
private static String driver;
private static String url;
private static String userName;
private static String passWord;
static{
driver="com.mysql.jdbc.Driver";
url="jdbc:mysql://localhost:3306/網頁資料";
userName="root";
passWord="123";
}
public static Connection open(){
try {
Class.forName(driver);
return DriverManager.getConnection(url,userName,passWord);
} catch (Exception e) {
// TODO 自動生成的 catch 塊
e.printStackTrace();
return null;
public static void close(Connection conn){
if(conn!=null){
conn.close();
} catch (SQLException e) {