package db;
import java.io.*;
import java.sql.*;
import java.util.*;
public class DbConnection {
Connection conn;
Statement stmt;
ResultSet rset;
private String password;
private String url;
private String user ;
private String jdbc;
public DbConnection() {
}
public boolean openConnection() throws SQLException{
System.out.println("ksjfsa");
InputStream is = getClass().getResourceAsStream("db.txt");//取自配置文件
Properties prop = new Properties();
try {
prop.load(is);
System.out.println("prop");
}
catch (IOException ex) {
}
if (is != null) {
try {
is.close();
}
catch (IOException ex1) {
}}
jdbc = prop.getProperty("driver");
url = prop.getProperty("url");
user= prop.getProperty("user");
password = prop.getProperty("password");
try {
Class.forName(jdbc);
}
catch (ClassNotFoundException ex2) {
ex2.printStackTrace();
}
conn = DriverManager.getConnection(url, user, password);
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
return true;
}
public ResultSet exceuteQuery(String query) throws SQLException{
return stmt.executeQuery(query);
}
public void executeUpdate(String query) throws SQLException{
stmt.executeUpdate(query);
}
public void close(){
try {
if (conn != null) {
conn.close();
}
if (stmt != null) {
stmt.close();
}
if (rset != null) {
rset.close();
}
}
catch (SQLException ex) {
}
}
public void finalize(){
this.close();}
public void closeRst(){
stmt =null;
rset=null;
}
}
配置文件
//fileName db.txt
driver=com.microsoft.jdbc.sqlserver.SQLServerDriver
url=jdbc:microsoft:sqlserver://192.168.0.122:1433;DatabaseName=c
user=sa
passwor=
import java.io.*;
import java.sql.*;
import java.util.*;
public class DbConnection {
Connection conn;
Statement stmt;
ResultSet rset;
private String password;
private String url;
private String user ;
private String jdbc;
public DbConnection() {
}
public boolean openConnection() throws SQLException{
System.out.println("ksjfsa");
InputStream is = getClass().getResourceAsStream("db.txt");//取自配置文件
Properties prop = new Properties();
try {
prop.load(is);
System.out.println("prop");
}
catch (IOException ex) {
}
if (is != null) {
try {
is.close();
}
catch (IOException ex1) {
}}
jdbc = prop.getProperty("driver");
url = prop.getProperty("url");
user= prop.getProperty("user");
password = prop.getProperty("password");
try {
Class.forName(jdbc);
}
catch (ClassNotFoundException ex2) {
ex2.printStackTrace();
}
conn = DriverManager.getConnection(url, user, password);
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
return true;
}
public ResultSet exceuteQuery(String query) throws SQLException{
return stmt.executeQuery(query);
}
public void executeUpdate(String query) throws SQLException{
stmt.executeUpdate(query);
}
public void close(){
try {
if (conn != null) {
conn.close();
}
if (stmt != null) {
stmt.close();
}
if (rset != null) {
rset.close();
}
}
catch (SQLException ex) {
}
}
public void finalize(){
this.close();}
public void closeRst(){
stmt =null;
rset=null;
}
}
配置文件
//fileName db.txt
driver=com.microsoft.jdbc.sqlserver.SQLServerDriver
url=jdbc:microsoft:sqlserver://192.168.0.122:1433;DatabaseName=c
user=sa
passwor=