二、例子import java.sql.*;public class ConnMySQL{public static void main(String[] args) throws Exception{//加载MySQL驱动Class.forName("com.mysql.jdbc.Driver");//获取数据库连接Connection conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test_cyw","root","root");//通过Connection对象创建Statement对象Statement stmt = conn.createStatement();//ResultSet rs = stmt.executeQuery("select * from t_student");while(rs.next()){System.out.println(rs.getInt(1) + "\t"+ rs.getString(2) + "\t"+ rs.getString(3));}//关闭数据库资源if(rs != null){rs.close();}if(stmt != null){stmt.close();}if(conn != null){conn.close();}}}---------------在操作过程中出现问题:1.JDBC数据库连接异常异常情况:Exception in thread "main" java.lang.ClassNotFoundException: com.mysql.jdbc.Driver问题说明:找不到mysql的驱动类解决方法:在环境变量的CLASSPATH中添加mysql-connector-java-5.1.20-bin.jar就可以了本机的路径是:C:\Program Files\MySQL\MySQL Connector J\mysql-connector-java-5.1.20-bin.jar2.MySql中文显示乱码mysql> select * from t_student;+----+------+-----+| ID | NAME | SEX |+----+------+-----+| 1 | cyw | 鐢? || 2 | ly | 鐢? || 3 | gs | 濂? |+----+------+-----+3 rows in set (0.00 sec)解决方法:mysql> set names 'gbk'对JDBC对数据库的连接,目前只是对MySQL的连接,分享和大家互相学习
jdbc连接mysql示意图_JDBC连接MySQL
最新推荐文章于 2024-02-04 11:08:02 发布