Myeclipse简单地链接数据库

来源：互联网发布：百度云的域名怎么转发编辑：程序博客网时间：2024/06/03 22:40

首先新建一个web project

1、mysql的链接jar包：http://download.csdn.net/download/qq_34926773/9968477

2、在 Eclipse 的 Java 工程中新建一个 lib 文件夹，将所准备的 JAR 包复制进去。

3、右键该 JAR 包：Build Path --> Add to Build Path

private String jdbcDriver = "com.mysql.jdbc.Driver";private String jdbcUrl = "jdbc:mysql://localhost:3306/test";private String jdbcUser = "root";private String jdbcPass = "123456";

//添加员工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();}return flag;}

阅读全文

1 0