package forum.datasource;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import com.microsoft.jdbc.sqlserver.SQLServerDriver;
public final class DataConn {
/**
* @姚伟男
*数据源
*/
private Connection connection=null;
private static DataConn instance=null;
private DataConn(){
try {
new SQLServerDriver();
connection=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databaseName=forum","sa","yaoweiwei");
} 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 static void main(String[] args) {
// DataConn d=getInstance();
// PreparedStatement p=null;
// try {
// p = d.getConnection().prepareStatement("select *from forum_forums");
// } catch (SQLException e1) {
// // TODO Auto-generated catch block
// e1.printStackTrace();
// }
// ResultSet set=null;
// try {//set=p.execute();
// set=p.executeQuery();
// while (set.next()) {
// System.out.print(set.getString(2));
// }
//
// } catch (SQLException e) {
// // TODO Auto-generated catch block
// e.printStackTrace();
// }
//
// }
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import com.microsoft.jdbc.sqlserver.SQLServerDriver;
public final class DataConn {
/**
* @姚伟男
*数据源
*/
private Connection connection=null;
private static DataConn instance=null;
private DataConn(){
try {
new SQLServerDriver();
connection=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databaseName=forum","sa","yaoweiwei");
} 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 static void main(String[] args) {
// DataConn d=getInstance();
// PreparedStatement p=null;
// try {
// p = d.getConnection().prepareStatement("select *from forum_forums");
// } catch (SQLException e1) {
// // TODO Auto-generated catch block
// e1.printStackTrace();
// }
// ResultSet set=null;
// try {//set=p.execute();
// set=p.executeQuery();
// while (set.next()) {
// System.out.print(set.getString(2));
// }
//
// } catch (SQLException e) {
// // TODO Auto-generated catch block
// e.printStackTrace();
// }
//
// }
}