笔试题：写一个mysql、Oracle、sqlserver(可选)数据库连接

Question

搞忘了怎么写

Answer 1

先写一个通用的数据库连接类
[code="java"]public class CommonConst
{
//数据库连接常量
public static String DB_DRIVER_CLASSNAME="com.microsoft.sqlserver.jdbc.SQLServerDriver";
public static String public static String DB_CONN_STRING = "jdbc:sqlserver://localhost:1433;DatabaseName=xxx;user=xx;password=xx";
[/code]
}

连接数据库方法
[code="java"]
try
{
//载入SQLServer的JDBC驱动类
Class.forName(CommonConst.DB_DRIVER_CLASSNAME);
//获得数据库连接
Connection conn = DriverManager.getConnection( CommonConst.DB_CONN_STRING );

        Statement stmt = null;
        ResultSet rs = null;

        String sUsername = (String)mySession.getAttribute("username");

        try
        {
            //准备检索数据库
            stmt = conn.createStatement();

            //获取数据库中地址簿中的所有记录
            Vector vAddresses = new Vector();
            String sQuery = "select * from address where username='" + sUsername + "' order by friend_name";
            rs = stmt.executeQuery( sQuery );
            while ( rs.next() )
            {
                String sFriendName      = rs.getString(2);
                String sFriendMail     = rs.getString(3);

                MailAddress ma = new MailAddress();
                ma.setFriendName(sFriendName);
                ma.setFriendMail(sFriendMail);

                vAddresses.add( ma );
            }

            myValues.put( "addresses", vAddresses );
        }
        catch(Exception e)
        {
            conn.rollback();
            e.printStackTrace();
            mySession.setAttribute("errMsg","查找地址簿时出现错误！");
            return false;
        }
        finally
        {
            try
            {
                rs.close();
                stmt.close();
            }catch(Exception ex)
            {
            }
        }
    }catch(Exception ex)
    {
        ex.printStackTrace();
        mySession.setAttribute("errMsg","查找地址簿时出现错误！");
        return false;
    }

    return true;
}

[/code]