package dbconn;
import java.sql.*;
public class DBconn {
private Connection con=null;
private Statement st=null;
private ResultSet rs=null;
private String drivername = "oracle.jdbc.driver.OracleDriver";
private String theURL = "jdbc:oracle:thin:@10.0.1.255:1521:databasename"; //1521 是端口号;databasename是全局数据库名;
//private String drivername = "org.gjt.mm.mysql.Driver";
//private String theURL = "JDBC:mysql://localhost/databasename?user=root&password=root&useUnicode=true&characterEncoding=8859_1";
// localhost是数据库服务器的ip地址;databasename是数据库名;useUnicode=true&characterEncoding=8859_1 可不写
//private String drivername = "com.microsoft.JDBC.sqlserver.SQLServerDriver";
//private String theURL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
/* db2数据库
<%Class.forName("com.ibm.db2.JDBC.app.DB2Driver ").newInstance(); String url="jdbc:db2://localhost:5000/sample"; //sample为你的数据库名 String user="admin"; String password=""; Connection conn= DriverManager.getConnection(url,user,password); Statement stmt=conn.createStatement (ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
*/
String username = "username";
String password = "password";
public Connection getConnection() {
try {
Class.forName(drivername);
con = DriverManager.getConnection(theURL,username,password); //oracle和sql在这里一样
//con = DriverManager.getConnection(theURL); //mysql 要用&分隔
} catch(ClassNotFoundException e) {
e.printStackTrace();
} catch(SQLException e) {
e.printStackTrace();
}
finally {
System.out.println("Connection success!!!");
}
return con;
}
public ResultSet selectSql(String sql)//执行对数据库的查询操作 {
try {
st =getConnection().createStatement(); //使用Statement语句对象执行SQL语句 考虑安全可用 PreparedStatement
rs = st.executeQuery(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return rs;
}
public int updateSql(String sql)//执行对数据库的更新操作 {
int i=0;
try {
st = getConnection().createStatement();
i = st.executeUpdate(sql); //更新成功会返回一个大于零的数,即更新的条数,可通过此判断更新是否成功
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace(); }
return i;
}
public int deleteSql(String sql)//执行对数据库的删除操作 {
int i=0;
i= updateSql(sql);//删除操作的结果会是一个数 如果删除成功会返回一个大于0的数
return i;
}
public int insertSql(String sql) {
int i = 0;
i = updateSql(sql); return i;
}
public void closeConn() {
try {
if(con!=null) {
con.close();
}
if(st!=null) {
st.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally {
System.out.println("Connection closed!!!");
}
}
public void closeAllConn() {
try {
if(con!=null) {
con.close();
}
if(st!=null) {
st.close();
}
if(rs!=null) {
rs.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally {
System.out.println("Connection closed!!!");
}
}
}