Br_Info.zip_jsp通讯录

package com.txl.userdao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import com.txl.user.User; import com.txl.util.JDBCConnection; public class UserDAO { // 查询 public User search(String name) { User user = null; String sql = "select * from txll where name = ?"; System.out.println(sql); Connection conn = null; PreparedStatement st = null; ResultSet rs = null; try { // 建立数据库连接 conn = JDBCConnection.getConnection(); st = conn.prepareStatement(sql); st.setString(1, name);// 执行SQL语句 rs = st.executeQuery();// 处理结果集 if (rs.next()) { user = new User(); user.setName(rs.getString("name")); user.setNum(rs.getString("num")); user.setPhone(rs.getString("phone")); user.setTell(rs.getString("tell")); user.setAddress(rs.getString("address")); user.setEmail(rs.getString("email")); user.setBeizhu(rs.getString("beizhu")); rs.close(); st.close(); conn.close(); } } catch (SQLException se) { se.printStackTrace(); JDBCConnection.closeResultSet(rs); JDBCConnection.closeStatement(st); JDBCConnection.closeConnection(conn); } return user; } //添加 public void Add(User u) { String sql = "insert into txll(name,phone,tell,address,email,beizhu) values(?,?,?,?,?,?)"; System.out.println(sql); Connection conn = null; PreparedStatement st = null; try { // 建立数据库连接 conn = JDBCConnection.getConnection(); st = conn.prepareStatement(sql); st.setString(1, u.getName()); st.setString(2, u.getPhone()); st.setString(3, u.getTell()); st.setString(4, u.getAddress()); st.setString(5, u.getEmail()); st.setString(6, u.getBeizhu()); st.executeUpdate();// 执行SQL语句 st.close(); conn.close(); } catch (SQLException se) { se.printStackTrace(); JDBCConnection.closeStatement(st); JDBCConnection.closeConnection(conn); } } }