eclipse连接MySQL数据库

来源：互联网发布：matlab 优化线性规划编辑：程序博客网时间：2024/06/07 07:08

首先导入JDBC包

mysql-jdbc-CSDN下载点击打开链接

Eclipse工程连接Mysql说明_百度经验 https://jingyan.baidu.com/article/fb48e8be386b7c6e622e1488.html

然后就是在eclipse中建一个项目，编写语句如下：

String driver = "com.mysql.jdbc.Driver";String url = "jdbc:mysql://127.0.0.1:3306/sc";//3306是我的mysql占用端口号,sc是我提前建好的数据库String user = "root";//mysql用户名String password = "root";;//mysql密码Connection conn = null;PreparedStatement pstmt = null;ResultSet rs = null;try{//注：此次一定要加异常处理，因为diver不一定能正确找到//1.注册驱动Class.forName(driver);//2.获取链接conn = DriverManager.getConnection(url,user,password);//3.预处理sqlString sql = "select * from tbl_student";pstmt = conn.prepareStatement(sql);//4.执行sql操作（更新操作，查询操作）,如果有结果集处理集合rs = pstmt.executeQuery();while(rs.next()){long id = rs.getLong("id");String name = rs.getString("name");System.out.println(id+","+name);}}catch(Exception e){e.printStackTrace();}finally{//5.释放资源if(rs != null){rs.close();}if(pstmt != null){pstmt.close();}if(conn != null){conn.close();}}

另一种sql语句，更新，删除，修改操作，无结果集合：

//4.执行sqlString sql = "insert into tbl_student(name,birth) values(?,?)";//占位符PreparedStatement pstmt = conn.prepareStatement(sql);//5.替换占位符pstmt.setString(1, "terry");pstmt.setString(2,"女");int num = pstmt.executeUpdate();System.out.println("保存了"+num+"条信息");//更新操作，对所有数据有影响操作

阅读全文

0 0