JavaWeb学习笔记 JDBC创建 留档

JDBC创建

当然已经在lib中放入了jar包  mysql-connector-java-5.1.22-bin.jar

下面是在src中创建的包中类的代码

package cn.itcast.jdbc.example.dao;import java.sql.Connection;import java.sql.ResultSet;import java.sql.Statement;import java.text.SimpleDateFormat;import cn.itcast.jdbc.example.domain.User;import cn.itcast.jdbc.example.utils.JDBCUtils;public class UsersDao {public boolean insert(User user){Connection conn = null;Statement stmt = null;ResultSet rs = null;try {conn = JDBCUtils.getConnection();stmt = conn.createStatement();SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");//SimpleDateFormat sdf = new SimpleDateFormat("yyyy-mm-dd");String birthday = sdf.format(user.getBirthday());int  id = user.getId();String name = user.getUsername();String password = user.getPassword();String email = user.getEmail();String sql = "INSERT INTO users(id,name,password,email,birthday)"+"VALUES("+id+",'"+name+"','"+password+"','"+email+"','"+birthday+"')";int num = stmt.executeUpdate(sql);if(num>0){return true;}return false;} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();} finally{JDBCUtils.release(rs,stmt, conn);}return false;}}

 

package cn.itcast.jdbc.example.domain;import java.util.Date;public class User {private int id;private String username;private String password;private String email;private Date birthday;public int getId() {return id;}public void setId(int id) {this.id = id;}public String getUsername() {return username;}public void setUsername(String username) {this.username = username;}public String getPassword() {return password;}public void setPassword(String password) {this.password = password;}public String getEmail() {return email;}public void setEmail(String email) {this.email = email;}public Date getBirthday() {return birthday;}public void setBirthday(Date birthday) {this.birthday = birthday;}}

 

package cn.itcast.jdbc.example.utils;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class JDBCUtils {public static Connection getConnection() throws ClassNotFoundException, SQLException{Class.forName("com.mysql.jdbc.Driver");String url = "jdbc:mysql://localhost:3306/ch01";String user = "root";String password = "123456";Connection conn = DriverManager.getConnection(url, user, password);return conn;}public static void release(Statement stmt, Connection conn){if(stmt != null){try {stmt.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}stmt = null;}if(conn != null){try {conn.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}conn = null;}}public static void release(ResultSet rs,Statement stmt, Connection conn){if(rs != null){try {rs.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}rs = null;}release(stmt,conn);}}