dbconn.java

JSP的网上商城的代码。只是小部分。希望大家能够多看看。一起学习。

package com.eshop.database;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class dbconn {

 private Connection conn = null;
 ResultSet rs = null;
 Statement stmt = null;
 int flag = 0;
 private String server = "localhost";
 private String port = "3306";
 private String db = "eshop";
 private String user = "root";
 private String pass = "123456";
 private String drivername="com.mysql.jdbc.Driver";
 private String URL="jdbc:mysql://"+server+":"+port+"/"+db+"?user="+user+"&password="+pass;

 public dbconn(){//get database connection
  try{
   Class.forName(drivername).newInstance();
   conn = DriverManager.getConnection(URL);
  }
  catch(Exception e){
   e.printStackTrace();
  }
 }
 
 public ResultSet executeQuery(String str) {
	  try{
	   Statement stmt = conn.createStatement();
	   rs = stmt.executeQuery(str);
	  }
	  catch(Exception e){
	   e.printStackTrace();
	  }
	   return this.rs;
	 }
 
 public int excuteUpdate(String sql) throws SQLException{
	 Statement stmt = conn.createStatement();
	 flag = stmt.executeUpdate(sql);
	 return flag;
	 
 }
 
 public void close() throws SQLException{
	 if(rs != null)
		 rs.close();
	 if(stmt != null)
		 stmt.close();
	 if(conn != null)
		 conn.close();
	 }
 }