java查询_使用Java查询

package cn.jbit.epetShop.dao;

import java.io.IOException;

import java.io.InputStream;

import java.sql.*;

import java.util.Properties;

import cn.jbit.epetShop.dao.BaseDao;public classBaseDao {public staticString DRIVER;public staticString URL ;public staticString DBNAME;public staticString DBPASS;

Connection conn= null;static{

init();

}public static voidinit(){

Propertiesparams=newProperties();

String configFile= "database.properties";//配置文件路径//加载配置文件到输入流中

InputStream is=BaseDao.class.getClassLoader().getResourceAsStream(configFile);try{//从输入流中读取属性列表7

params.load(is);

}catch(IOException e) {

e.printStackTrace();

}//根据指定的获取对应的值

DRIVER=params.getProperty("driver");

URL=params.getProperty("url");

DBNAME=params.getProperty("user");

DBPASS=params.getProperty("password");

}//数据库连接

publicConnection getConn() throws ClassNotFoundException, SQLException {

Connection conn= null;try{

Class.forName(DRIVER);

conn=DriverManager.getConnection(URL, DBNAME, DBPASS);

}catch(SQLException e) {

e.printStackTrace();

}returnconn;

}public voidcloseAll(Connection conn, PreparedStatement pstmt, ResultSet rs) {if (rs != null) {try{

rs.close();

}catch(SQLException e) {

e.printStackTrace();

}

}if (pstmt != null) {try{

pstmt.close();

}catch(SQLException e) {

e.printStackTrace();

}

}if (conn != null) {try{

conn.close();

}catch(SQLException e) {

e.printStackTrace();

}

}

}public intexecuteSQL(String preparedSql, Object[] param) {

Connection conn= null;

PreparedStatement pstmt= null;int num = 0;/*处理SQL,执行SQL*/

try{

conn= getConn(); //得到数据库连接

pstmt = conn.prepareStatement(preparedSql); //得到PreparedStatement对象

if (param != null) {for (int i = 0; i < param.length; i++) {

pstmt.setObject(i+ 1, param[i]); //为预编译sql设置参数

}

}//System.out.println(preparedSql);

num = pstmt.executeUpdate(); //执行SQL语句

} catch(ClassNotFoundException e) {

e.printStackTrace();//处理ClassNotFoundException异常

} catch(SQLException e) {

e.printStackTrace();//处理SQLException异常

} finally{this.closeAll(conn, pstmt, null);

}returnnum;

}