java连接数据库进行增添数据的不同写法

一、

//连接数据库工具类

jdbc.properties:

driver = com.mysql.jdbc.Driver url = jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8 user = root pass =123456

public static Connection getConnection() throws Exception{Connection conn = null;try {//加载属性文件，读取数据库连接配置信息Properties pro = new Properties();try {pro.load(GetConn.class.getResourceAsStream("/jdbc.properties"));} catch (IOException e) {System.out.println("未找到配置文件！！！");}String url = pro.getProperty("url");String user = pro.getProperty("user");String pass = pro.getProperty("pass");Class.forName(pro.getProperty("driver"));conn = DriverManager.getConnection(url, user, pass);} catch (Exception e) {e.printStackTrace();}return conn;}

//添加员工public boolean saveEmp(){boolean flag = false;Connection conn = null; Statement st = null;try {//加载驱动Class.forName(jdbcDriver);conn = DriverManager.getConnection(jdbcUrl,jdbcUser,jdbcPass);String sql = "insert into emp values('7777','LZH','manger',"+null+",'2017-10-1','90000','10000','10')";st = conn.createStatement();int result = st.executeUpdate(sql);if(result > 0){flag = true;}} catch (Exception e) {e.printStackTrace();} finally {try {st.close();} catch (SQLException e) {e.printStackTrace();} finally {if(conn != null){try {conn.close();} catch (SQLException e) {e.printStackTrace();}}}}return flag;}

二、

EmpDao:

public boolean saveEmp2(Emp emp){boolean flag = false;Connection conn = null; PreparedStatement ps = null;//预编译结果集try {//加载驱动conn = DBConnectionUtil.getConnection();String sql = "insert into emp values (?,?,?,?,?,?,?,?)";ps = conn.prepareStatement(sql);ps.setInt(1, emp.getEmpno());ps.setInt(4, emp.getMgr());ps.setInt(6, emp.getSal());ps.setInt(8, emp.getDeptno());ps.setString(2, emp.getEname());ps.setString(3, emp.getJob());ps.setString(5, emp.getHiredate());ps.setInt(7, emp.getComm());int result = ps.executeUpdate();if(result > 0){flag = true;}} catch (Exception e) {e.printStackTrace();} finally {DBConnectionUtil.closeAll(ps, conn);}return flag;}