jdbc的操作流程代码

` // dbhelp help类，封装数据库基本信息以及关闭资源的方法

class DbHelp{
    //数据库连接信息
    public static String url = "jdbc:mysql://localhost:3306/blog";
    public static String user = "root";
    public static String password = "root";
    public static String driver = "com.mysql.jdbc.Driver";

    public static PreparedStatement ps = null;

    public static Connection conn = null;

    public ResultSet rs = null;

    //获取数据库连接的方法
    public static void getConnection(){
    try {
	        Class.forName(driver);
	        conn = DriverManager.getConnection(url, user, password);
	        } catch (ClassNotFoundException e) {
	                e.printStackTrace();
	        } catch (SQLException e) {
	                e.printStackTrace();
	        }
    }

    // 关闭资源
    public void close(){
      try {
		        ps.close();
		        conn.close();
                rs.close();
	        } catch (SQLException e) {
		            e.printStackTrace();
	        }
        }
    }

// User实体类
public class User{
private int id;
private String name;
private  String contact;
private String telephone;
private String email;
private String remark;
private String userName;
private String address;


@Override
public String toString() {
return "User [id=" + id + ", name=" + name + ", contact=" + contact
+ ", telephone=" + telephone + ", email=" + email + ", remark="
+ remark + ", userName=" + userName + ", address=" + address+ "]";
}
    // get/set 方法
    。。。。。。
}    



 //数据库操作类
public class UserDemo extends DbHelp{

    public User getUser(){
        getConnection();
        User user = new User();
        String sql = "select * from t_sys_user where user_id = ?";
        try{
            ps = conn.prepareStatement(sql);
            // 设置参数，第一个问号的值为 8
            ps.setInt(1,8)
            rs = ps.executeQuery();
            while(rs.next()){
                user.setId(rs.getInt("id"));
                user.setName(rs.getString("name"));
                user.setContact(rs.getString("contact"));
                user.setEmail(rs.getString("email"));
                user.setRemark(rs.getString("remark"));
                user.setTelephone(rs.getString("telephone"));
            }
            }catch(SQLException e){
                e.printStackTrace();
        } 
            //关闭资源
            close();
            return user;
        }
    }

  //测试方法
public static void main(String[] a){
        UserDemo demo = new UserDemo();
        User user = demo.get();
        System.out.println(user.toString());
}

`

转载于:https://my.oschina.net/u/2310996/blog/708685