javabeans连接mysql,JAVA通过Java Bean连接mysql基础教程

Java通过JDBC连接mysql。使用java bean提高了代码的重用。

package bean;

import java.sql.*;

import java.util.*;

import java.io.*;

/************************

* *

* author:jarwang *

* date:2007-4-10 *

* *

***********************/

public class dbConn {

public static Connection getConn(){

Connection conn = null;

try{

//通过JDBC连接Mysql

Class.forName("com.mysql.jdbc.Driver");

conn = DriverManager.getConnection("jdbc:mysql://192.168.1.3:3307/xs_web","user","pwd");

}

catch(Exception e){

System.out.println("get Connect erro: "+e);

}

return conn;

}

public static String CloseConn(Connection conn){

try{

conn.close();

}catch(Exception e){

System.out.println("close connect error"+e);

}finally{

try{

conn.close();

}catch(Exception e1){

System.out.println("close error e1"+e1);

}

}

return "success close conn";

}

public static ArrayList QueryRec(Connection conn,String sql){

Statement stmt = null;

ResultSet rs = null;

ArrayList aList = new ArrayList();

//Vector aVector = new Vector();

try{

stmt = conn.createStatement();

rs = stmt.executeQuery(sql);

//取得表的字段数

ResultSetMetaData rsmd = rs.getMetaData();

int aCount = rsmd.getColumnCount();

while(rs.next()){

Map weakMap = new Hashtable();

for(int i=1;i

String sColumnName = rsmd.getColumnName(i);

if(!(rs.getString(sColumnName) == null))

weakMap.put(sColumnName,rs.getString(sColumnName));

}

aList.add(weakMap);

}

}catch(Exception e){

System.out.println("qeury error:"+e);

}

return aList;

}

}