搞忘了怎么写
3条回答 默认 最新
- WdWheyr 2010-05-26 08:49关注
先写一个通用的数据库连接类
[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]
本回答被题主选为最佳回答 , 对您是否有帮助呢?解决 无用评论 打赏 举报