import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
public class DBconnection {
// 连接数据库
private Connection con = null;
private Statement stat = null;
protected ResultSet rs = null;
/*
*
* Oracle JAR包:Classes12.jar private final String DBDRIVER =
* "oracle.jdbc.driver.OracleDriver" ; private final String DBURL =
* "jdbc:oracle:thin:@IP:1521:数据名" ; private final String DBUSER = "用户名" ;
* private final String DBPASSWORD = "密码" ; private Connection conn=null ;
*
* //SQL Server三个JAR包 mssqlserver.jar,msbase.jar,msutil.jar private final
* String DBDRIVER = "com.microsoft.jdbc.sqlserver.SQLServerDriver" ;
* private final String DBURL =
* "jdbc:microsoft:sqlserver://IP:1433;DatabaseName=数据库名;" ; private final
* String DBUSER = "用户名" ; private final String DBPASSWORD = "密码" ; private
* Connection conn=null ;
*
* //SQL ServerJDBC-ODBC桥 private final String DBDRIVER =
* "sun.jdbc.odbc.JdbcOdbcDriver" ; private final String DBURL =
* "jdbc:odbc:数据源名" ; private final String DBUSER = "用户名" ; private final
* String DBPASSWORD = "密码" ; private Connection conn=null ;
*
* //MySQL JAR包 mysql-connector-java-3.1.12-bin.jar private final String
* DBDRIVER = "org.gjt.mm.mysql.Driver" ; private final String DBURL =
* "jdbc:mysql://IP /数据库名" ; private final String DBUSER = "用户名" ; private
* final String DBPASSWORD = "密码" ; private Connection conn=null ;
*
* //DB2 private final String DBDRIVER = "com.ibm.db2.jdbc.app.DB2Driver" ;
* private final String DBURL = "jdbc:db2://IP:5000/数据库名" ; private final
* String DBUSER = "用户名" ; private final String DBPASSWORD = "密码" ; private
* Connection conn=null ;
*/
public Connection getConnection() {
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url = "jdbc:sqlserver://192.168.0.1:1433;"
+ "databaseName=hos;user=username;password=password";
con = DriverManager.getConnection(url);
con.setAutoCommit(false);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return con;
}
// 得到结果集
public ResultSet getResultSet(String sql) {
if (con == null) {
con = this.getConnection();
}
try {
stat = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
rs = stat.executeQuery(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return rs;
}
// 插入和修改数据库
public int updateDataBase(String sql, Connection con) {
int i = -1;
try {
stat = con.createStatement();
i = stat.executeUpdate(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return i;
}
// 关闭连接
public void close() {
try {
if (rs != null) {
rs.close();
rs = null;
}
if (stat != null) {
stat.close();
stat = null;
}
if (con != null) {
con.close();
con = null;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
JDBC 连接数据库的类
最新推荐文章于 2022-08-26 23:24:58 发布