java连接mysql，测试通过

最新推荐文章于 2021-02-06 21:53:39 发布

惟亚

最新推荐文章于 2021-02-06 21:53:39 发布

阅读量574

点赞数

分类专栏： Java 211

本文链接：https://blog.csdn.net/rwliyawen/article/details/38400885

版权

Java 211 专栏收录该内容

14 篇文章 0 订阅

订阅专栏

实施步骤：

准备前，Navicat新建一个数据库student，新建表std，插入数据

1、新建java project,命名JDBC

2、导入mysql-connector-java-5.0.5-bin.jar进入referenced libraries

3、新建class，命名JDBCTest

代码如下：
import java.sql.*;
public class JDBCTest {
   public static void main(String[] args){
       String driver = "com.mysql.jdbc.Driver";    //驱动程序名，要和mysql-connector-java-5.0.5-bin.jary一致
       String url = "jdbc:MySQL://127.0.0.1:3306/student"; //URL指向要访问的数据库名scutcs
       String user = "root";
       String password = "123456";

try {
Class.forName(driver); //加载驱动程序

            Connection conn = DriverManager.getConnection(url, user, password);   //连续MySQL数据库
           if(!conn.isClosed())
               System.out.println("Succeeded connecting to the Database!");
           Statement statement = conn.createStatement();
           String sql = "select * from std";
           ResultSet rs = statement.executeQuery(sql); //获取rs结果集
           System.out.println(" 学号" + "\t" + " 姓名");
           System.out.println("-----------------");
           String name = null;
           while(rs.next()) {
               name = rs.getString("sname");
               name = new String(name.getBytes("ISO-8859-1"),"GB2312");
               System.out.println(rs.getString("sno") + "\t" + name);
           }
           rs.close();
           conn.close();
       } catch(ClassNotFoundException e) {
           System.out.println("Sorry,can`t find the Driver!");
           e.printStackTrace();
       } catch(SQLException e) {
           e.printStackTrace();
       } catch(Exception e) {
           e.printStackTrace();
       }
   }
}