conn.java

自己写的登陆框架 用到数据库 请大家多多指教

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.PreparedStatement;
import java.util.ArrayList;

public class Conn{
	private Connection getCon(){
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}catch(Exception e){
			e.printStackTrace();
		}
		Connection con = null;
		try{
			con = DriverManager.getConnection("jdbc:odbc:userlogin","sa","");
		}catch(Exception e){
			e.printStackTrace();
			return null;
		}finally{
			return con;
		}
	}
	public ArrayList select(String login){
		Connection con = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		ArrayList array = new ArrayList();
		try{
			con = this.getCon();
			ps = con.prepareStatement("select * from login_name where login_name=?");
			ps.setString(1,login);
			rs = ps.executeQuery();
			if(rs.next()){
				Data data = new Data();
				data.setLogin(rs.getString(1));
				data.setName(rs.getString(2));
				data.setAge(rs.getInt(3));
				array.add(data);
			}
		}catch(Exception e){
			e.printStackTrace();
			return null;
		}finally{
			try{
				if(rs != null){
					rs.close();
				}
				if(ps != null){
					ps.close();
				}
				if(con != null){
					con.close();
				}
			}catch(Exception e){
			}
			return array;
		}
	}
}