转自论坛的贴:
用JSP查询数据库信息然后显示如何做?
回复:
package com.musicStore.dao.impl;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class BaseDao {
//定义连接,命令,和结果集
protected Connection connection;
protected PreparedStatement pStatement;
protected ResultSet resultSet;
//定义数据库连接参数
private String driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";
private String connUrl="jdbc:sqlserver://localhost:1433;DatabaseName=MusicStore";
private String uId="sa";
private String pwd="123";
//打开数据连接
public void openDb(){
try {
Class.forName(driverName);
connection=DriverManager.getConnection(connUrl,uId,pwd);
} catch (Exception e) {
e.printStackTrace();
}
}
//关闭数据连接,释放资源
public void closeDb(){
try {
if(pStatement!=null)
pStatement.close();
if(resultSet!=null)
resultSet.close();
if(connection!=null)
connection.close();
} catch (Exception e) {
e.printStackTrace();
}
}
//设置参数
private void preparams(String sql,Object[] parms) throws SQLException{
pStatement=connection.prepareStatement(sql);
if(parms!=null){
for(int i=0;i<parms.length;i++){
pStatement.setObject(i+1, parms[i]);
}
}
}
//执行查询
public ResultSet exeQurey(String sql,Object[] parms) throws SQLException{
preparams(sql, parms);
resultSet=pStatement.executeQuery();
return resultSet;
}
//执行增,删,改
public int exeUpdate(String sql,Object[] parms) throws SQLException{
preparams(sql, parms);
return pStatement.executeUpdate();
}
}