JSPDemo2.zip

package dao; import java.io.IOException; import java.io.InputStream; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.Properties; import javax.naming.Context; import javax.naming.InitialContext; import javax.naming.NamingException; import javax.sql.DataSource; public class BaseDao { Connection connection; ResultSet rs; PreparedStatement pstm; static String driver; static String url; static String user; static String pwd; static{ init(); } public static void init() { Properties properties=new Properties(); String path="database.properties"; InputStream is=BaseDao.class.getClassLoader().getResourceAsStream(path); try { properties.load(is); driver=properties.getProperty("driver"); url=properties.getProperty("url"); user=properties.getProperty("user"); pwd=properties.getProperty("password"); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public Connection getConnection() { try { Class.forName(driver); connection=DriverManager.getConnection(url,user,pwd); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } return connection; } public void closeAll() { try { if(rs!=null){ rs.close(); } if(pstm!=null){ pstm.close(); } if(connection!=null){ connection.close(); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public int executeUpdate(String sql,Object obj[]) { int num=0; try { pstm=getConnection().prepareStatement(sql); if(obj!=null){ for(int i=0;i<obj.length;i++){ pstm.setObject(i+1, obj[i]); } } num=pstm.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return num; } public ResultSet executeQuery(String sql,Object obj[]) { try { pstm=getConnection().prepareStatement(sql); if(obj!=null){ for(int i=0;i<obj.length;i++){ pstm.setObject(i+1, obj[i]); } } rs=pstm.executeQuery(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return rs; } }