Java连mysq.docVIP

Java连接mysql 仅为参考代码，看着修改就可以了。具体的连接数据库的方法都在这里面了。 package test; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; public class DbAccess { private Connection conn=null; //private PreparedStatement ptst=null; //private ResultSet rs=null; private static final String driverName=org.gjt.mm.mysql.Driver; private static final String url=jdbc:mysql://localhost:3306/web; private static final String username=admin;//bobpm private static final String password=admin;//bpm private static final String tableName=tablename; static { try { Class.forName(driverName); } catch (ClassNotFoundException e) { e.printStackTrace(); } } public DbAccess() { } //数据库连接 private Connection getConn() { try { conn = DriverManager.getConnection(url,username,password); } catch (SQLException e) { e.printStackTrace(); return null; } return conn; } //查询数据 public List getlstTargetFile( ) { PreparedStatement ptst=null; ResultSet rs=null; conn=getConn(); if(null==conn) { return null; } ListDrillInfo lstFiles=new ArrayListDrillInfo(); DrillInfo drillInfo=null; String sql=select distinct b.target_file,b.target_name from +tableName+ b; try { ptst=conn.prepareStatement(sql); rs=ptst.executeQuery(); while(rs.next()) { drillInfo=new DrillInfo(); drillInfo.settarget_file(rs.getString(target_file)); drillInfo.settarget_name(rs.getString(target_name)); lstFiles.add(drillInfo); } return lstFiles; } catch (SQLException e) { e.printStackTrace(); return null; } finally { try { if(null!=conn) { conn.close(); conn=null; } if(null!=rs) { rs.close(); rs=null; } if(null!=ptst) { ptst.close(); ptst=null; } } catch (Exception e2