Javaç¨åºåæ°æ®åºä¸æå
¥æ°æ®ï¼ä»£ç å¦ä¸ï¼
//é¦å
å建æ°æ®åºï¼(access,oracle,mysql,sqlsever)å
¶ä¸ä¹ä¸ï¼å
¶ä¸access,sqlseveréè¦é
ç½®æ°æ®æº(odbc);
//ç¶ååeclipseä¸å建类(ConnDb,Testï¼TestBean)ConnDbåè½ä¸ºè¿æ¥æ°æ®åºï¼æ¥è¯¢ï¼æå
¥ï¼å é¤ï¼ä¿®æ¹æ°æ®çç±»ï¼Test为å«æmainæ¹æ³çæµè¯ç±»ï¼TestBean为æ°æ®è¡¨ä¸çå段å±æ§åset,getæ¹æ³
//以ä¸æ¯ConnDb代ç ï¼
package db;
import java.sql.Connection;
import java.sql.DriverManager;
import
java.sql.ResultSet;
import java.sql.SQLException;
import
java.sql.Statement;
import java.util.ArrayList;
public class ConnDb {
public Connection startConn(Connection conn){
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection("jdbc:odbc:æ°æ®åº","ç¨æ·å", "å¯ç ");
} catch (Exception e) {
System.out.println("è¿æ¥æ°æ®åºæ¶åºç°é误");
}
return conn;
}
public ArrayList executeQuery(String sql){
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
ArrayList list = new ArrayList();
try {
conn = startConn(conn);
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);//sql为sqlè¯å¥ä¾å¦"select * from
表å"ï¼ä»mainæ¹æ³ä¸ä¼ è¿æ¥ï¼è¿éç¨çæ¯ArrayList ç±»å°æ¥è¯¢ç»æåå¨èµ·æ¥
while(rs.next()){
TestBean tb = new TestBean();
tb.setTid(rs.getString("tid"));
tb.setTname(rs.getString("tname"));
tb.setTinfo(rs.getString("tinfo"));
list.add(tb);
}
}
catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
closeConn(rs,stmt,conn);
}
return list;
}
public void executeUpdate(String sql){
Connection conn = null;
Statement stmt = null;
try {
conn =
startConn(conn);
stmt = conn.createStatement();
stmt.executeUpdate(sql);
}
catch (SQLException e) {
System.out.println("ä¿®æ¹ï¼æå
¥æè
å é¤æ°æ®åºæ°æ®æ¶åçé误!");
}finally{
closeConn(stmt,conn);
}
}
public void closeConn(ResultSet rs,Statement stmt,Connection conn){
try {
if(rs !=
null){
rs.close();
}
if(stmt != null){
stmt.close();
}
if(conn != null){
conn.close();
}
}
catch (SQLException e) {
// TODO Auto-generated catch
block
System.out.println("å
³éæ°æ®åºçæ¶ååçé误!");
}
}
public void closeConn(Statement stmt,Connection conn){
try {
if(stmt != null){
stmt.close();
}
if(conn != null){
conn.close();
}
}
catch (SQLException e) {
// TODO Auto-generated catch block
System.out.println("å
³éæ°æ®åºçæ¶ååçé误!");
}
}
}