package data;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public final class DataConn {
/**
* @姚伟男
*/
private Connection connection=null;
private PreparedStatement statement=null;
private static DataConn instance=null;
private DataConn(){
try {
new com.mysql.jdbc.Driver();
connection=DriverManager.getConnection("jdbc:mysql://localhost:3306/mysite","root","yaoweiwei");
statement=connection.prepareStatement("use mysite");
} catch (SQLException e) {
System.out.println("数据库打开失败");
e.printStackTrace();
}
}
public static DataConn getInstance(){
if(instance==null)instance=new DataConn();
return instance;
}
public Connection getConnection() {
return connection;
}
public PreparedStatement getPaPreparedStatement(){
return statement;
}
// public static void main(String[] args) {
// DataConn d=getInstance();
// PreparedStatement p=d.getPaPreparedStatement();
// ResultSet set=null;
// try {
// set=p.executeQuery("select *from link_tb");
// while(set.next()){
// System.out.println(set.getString(2));
// }
// } catch (SQLException e) {
//
// e.printStackTrace();
// }
//
// }
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public final class DataConn {
/**
* @姚伟男
*/
private Connection connection=null;
private PreparedStatement statement=null;
private static DataConn instance=null;
private DataConn(){
try {
new com.mysql.jdbc.Driver();
connection=DriverManager.getConnection("jdbc:mysql://localhost:3306/mysite","root","yaoweiwei");
statement=connection.prepareStatement("use mysite");
} catch (SQLException e) {
System.out.println("数据库打开失败");
e.printStackTrace();
}
}
public static DataConn getInstance(){
if(instance==null)instance=new DataConn();
return instance;
}
public Connection getConnection() {
return connection;
}
public PreparedStatement getPaPreparedStatement(){
return statement;
}
// public static void main(String[] args) {
// DataConn d=getInstance();
// PreparedStatement p=d.getPaPreparedStatement();
// ResultSet set=null;
// try {
// set=p.executeQuery("select *from link_tb");
// while(set.next()){
// System.out.println(set.getString(2));
// }
// } catch (SQLException e) {
//
// e.printStackTrace();
// }
//
// }
}