用JAVA 编程的简单网上购书系统

package com.briup.dao.impl; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import com.briup.bean.Customer; import com.briup.dao.ICustomerDao; public class CustomerDaoImpl implements ICustomerDao { private String driver = "com.mysql.jdbc.Driver"; private String url = "jdbc:mysql://202.207.23.219:3306/test"; private String username = "root"; private String password = "220317"; private Connection con = null; private PreparedStatement stmt = null; private ResultSet rs = null; private String sql = null; public Customer findCustomerByName(String name) throws Exception { try { // 加载MySql驱动 Class.forName(driver); System.out.println("加载mysql驱动成功！！！"); // 创建connection连接 Connection con = DriverManager.getConnection(url, username, password); System.out.println("创建connection连接成功"); String sql = "select * from customer where name=?"; PreparedStatement stmt = con.prepareStatement(sql); stmt.setString(1, name); ResultSet rs = stmt.executeQuery(); Customer c = null; if (rs.next()) { c = new Customer(); Long id = rs.getLong("id"); String uname = rs.getString("name"); String pass = rs.getString("password"); String zip = rs.getString("zip"); String address = rs.getString("address"); String tel = rs.getString("telephone"); String email = rs.getString("email"); c.setId(id); c.setName(uname); c.setPassword(pass); c.setZip(zip); c.setAddress(address); c.setTelephone(tel); c.setEmail(email); } return c; } catch (SQLException e) { e.printStackTrace(); } finally { if (rs != null) { rs.close(); } if (stmt != null) { stmt.close(); } if (con != null) { con.close(); } } return null; } public void saveCustomer(Customer customer) throws Exception { // 加载MySql驱动 Class.forName(driver); System.out.println("加载mysql驱动成功！！！"); // 创建connection连接 Connection con = DriverManager.getConnection(url, username, password); System.out.println("创建connection连接成功"); String sql = "insert into customer(name,password,zip,address,telephone,email) values(?,?,?,?,?,?)"; PreparedStatement stmt = con.prepareStatement(sql); stmt.setString(1, customer.getName()); stmt.setString(2, customer.getPassword()); stmt.setString(3, customer.getZip()); stmt.setString(4, customer.getAddress()); stmt.setString(5, customer.getTelephone()); stmt.setString(6, customer.getEmail()); stmt.executeUpdate(); } public void updateCustomer(Customer customer) throws Exception { try { Class.forName(driver); con = DriverManager.getConnection(url, username, password); sql = "update customer set password=?,zip=?,address=?,telephone=?,email=? where name=?"; stmt = con.prepareStatement(sql); stmt.setString(1, customer.getPassword()); stmt.setString(2, customer.getZip()); stmt.setString(3, customer.getAddress()); stmt.setString(4, customer.getTelephone()); stmt.setString(5, customer.getEmail()); stmt.setString(6, customer.getName()); stmt.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } finally { if (rs != null) { rs.close(); } if (stmt != null) { stmt.close(); } if (con != null) { con.close(); } } } }