JDBC-MSSQL,MYSQL

最新推荐文章于 2022-04-18 08:00:00 发布

qq_32444825

最新推荐文章于 2022-04-18 08:00:00 发布

阅读量173

点赞数

分类专栏： Java

本文链接：https://blog.csdn.net/qq_32444825/article/details/88587115

版权

Java 专栏收录该内容

154 篇文章 2 订阅

订阅专栏

//MSSQL
   @Test
   public void getMSSQL() {
       String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; // 加载JDBC驱动
       String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=MEP"; // 连接服务器和数据库sample
       String userName = "sa"; // 默认用户名
       String userPwd = "1"; // 密码
       Connection dbConn;

       try {
           Class.forName(driverName);
           dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
           System.out.println("Connection Successful! "); // 如果连接成功

           if(!dbConn.isClosed()){
               System.out.println("mssql连接成功！");
               //创建Statement对象
               Statement st=dbConn.createStatement();
               //执行sql
               String sql="select *from user_info";
               ResultSet rs=st.executeQuery(sql);
               //获取查询结果
               while(rs.next()){
                   System.out.println("ok");
                   System.out.println("id:"+rs.getInt("user_id")+"name:"+rs.getString("user_name"));
               }
               //关闭资源
               rs.close();
               //关闭数据库
               dbConn.close();
           }else{
               System.out.println("连接失败！");
           }
       } catch (Exception e) {
           e.printStackTrace();
       }

=====================

//MYSQL

@Test
   public void getMysql(){


       String drive="com.mysql.jdbc.Driver";
       String url="jdbc:mysql://localhost:3306/crm?characterEncoding=utf-8";
       String user="root";
       String password="root";

       System.out.println("ok");

       try{
           System.out.println("ok");
           Connection conn=null;
           //加载驱动到 jvm
           Class.forName(drive);
           conn=DriverManager.getConnection(url,user,password);
           //判断数据库是否连接成功
           if(!conn.isClosed()){
               System.out.println("mssql连接成功！");
               //创建Statement对象
               Statement st=conn.createStatement();
               //执行sql
               String sql="select *from user_info";
               ResultSet rs=st.executeQuery(sql);
               //获取查询结果
               while(rs.next()){
                   System.out.println("ok");
                   System.out.println("id:"+rs.getInt("user_id")+"name:"+rs.getString("user_name"));
               }
               //关闭资源
               rs.close();
               //关闭数据库
               conn.close();
           }else{
               System.out.println("连接失败！");
           }
           //return conn;
       }catch(Exception ex){
           System.out.println("mssql连接失败！");
           ex.printStackTrace();
           //return null;
       }