连接数据库

package ca.utils;

import java.sql.*;

public class JDBCconnect {

    private final String url = "jdbc:mysql://localhost:3306/stu";

                                                     //设置数据库url驱动和数据库连接

    private final String user = "root";//设置连接的用户名

    private final String password = "123";//设置登录密码

    private Connectioncon =null;//设置数据库连接类的对象

    static{     

       try {

           //加载数据库驱动

           Class.forName("com.mysql.jdbc.Driver");

       } catch (Exception e) {

           System.out.printf("数据库驱动加载失败");

       }

    }

    //创建数据库连接

    public boolean createConnection(){

       try {

           con=DriverManager.getConnection(url,user,password);

       } catch (SQLException e) {

           System.out.printf("创建数据库连接失败");

       }

       return true;

    }

    //增删改

    public boolean executeUpdate(String sql){

       if(con==null){

           createConnection();

       }

       try {

           Statement stmt=con.createStatement();//创建声明连接

           int x=stmt.executeUpdate(sql);

           System.out.println("操作成功，所影响的记录数为" + String.valueOf(x));

           return true;

       } catch (SQLException e) {

           e.printStackTrace();

           return false;

       }

    }

    //查询

    public ResultSet executeQuery(String sql){      

       if(con==null){

           createConnection();

       }

       Statement stmt;

       ResultSet rs;

       try {

           stmt = con.createStatement();

           rs=stmt.executeQuery(sql);

       } catch (SQLException e) {

           e.printStackTrace();

           return null;

       }     

       return rs;

    }

}