//dao层 //数据库连接类
package com.xinzhan.dao;
import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException;
public class DbManager { static{ try {
Class.forName(\;
} catch (ClassNotFoundException e) { // TODO Auto-generated catch block
e.printStackTrace(); } }
public DbManager(){ }
public static Connection getCon(){ Connection con = null; try {
con =
DriverManager.getConnection(\://localhost:3306/mystudent_info?useUnicode=true&characterEncoding=gb2312\ot\
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace(); }
return con; }
public static void closeAll(ResultSet rs,PreparedStatement
pst,Connection
con){ block
try { if(null!=rs){ rs.close(); }
} catch (SQLException e) {
// TODO Auto-generated e.printStackTrace(); }finally{ try {
if(null!=pst){ pst.close(); }
} catch (SQLException e) {
catch // TODO Auto-generated catch block
e.printStackTrace(); }finally{ try {
if(null!=con){ con.close(); }
} catch (SQLException e) { // catch block
e.printStackTrace(); } } }
TODO
Auto-generated