1 import java.sql.Connection; 2 import java.sql.DriverManager; 3 import java.sql.PreparedStatement; 4 import java.sql.ResultSet; 5 import java.sql.SQLException; 6 7 public class JdbcUtil { 8 9 private String driver="oracle.jdbc.driver.OracleDriver"; 10 private String url="jdbc:oracle:thin:@localhost:8080: dbName"; 11 private String username="username"; 12 private String password="password"; 13 14 private Connection conn = null; 15 private PreparedStatement pstmt = null; 16 private ResultSet rst = null; 17 18 public UserEntity query(String value){ 19 String sql = "select user_id,user_name,phone from p_m_user where user_id =" + value; 20 UserEntity user = new UserEntity(); 21 22 try { 23 Class.forName(driver); 24 conn = DriverManager.getConnection(url, username, password); 25 pstmt = conn.prepareStatement(sql); 26 rst = pstmt.executeQuery(); 27 if(rst.next()){ 28 user.setUser_id(rst.getString("user_id")); 29 user.setUser_name(rst.getString("user_name")); 30 user.setPhone(rst.getNString("phone")); 31 } 32 rst.close(); 33 pstmt.close(); 34 conn.close(); 35 } catch (ClassNotFoundException e) { 36 // TODO Auto-generated catch block 37 e.printStackTrace(); 38 } catch(SQLException e2){ 39 e2.printStackTrace(); 40 } 41 return user; 42 } 43