package com.ck.DButil;
import java.sql.*;
public class DButil {
private static Connection conn=null;
private static PreparedStatement ps=null;
private static ResultSet rs=null;
public static PreparedStatement getPs(String sql){
try {
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/shop?" +
"relaxAutoCommit=true&zeroDateTimeBehavior=convertToNull";
String user="root";
String password="root";
conn=DriverManager.getConnection(url, user, password);
ps = conn.prepareStatement(sql);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return ps;
}
public static int executeUpdate(){
int a=0;
try {
a=ps.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return a;
}
public static ResultSet executeQuery(){
try {
rs=ps.executeQuery();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return rs;
}
public static void close(){
try {
if(rs!=null){
rs.close();
}
if(ps!=null){
ps.close();
}
if(conn!=null){
conn.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
import java.sql.*;
public class DButil {
private static Connection conn=null;
private static PreparedStatement ps=null;
private static ResultSet rs=null;
public static PreparedStatement getPs(String sql){
try {
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/shop?" +
"relaxAutoCommit=true&zeroDateTimeBehavior=convertToNull";
String user="root";
String password="root";
conn=DriverManager.getConnection(url, user, password);
ps = conn.prepareStatement(sql);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return ps;
}
public static int executeUpdate(){
int a=0;
try {
a=ps.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return a;
}
public static ResultSet executeQuery(){
try {
rs=ps.executeQuery();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return rs;
}
public static void close(){
try {
if(rs!=null){
rs.close();
}
if(ps!=null){
ps.close();
}
if(conn!=null){
conn.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
不过楼主新年快乐。。