JDBC连接数据库

JDBC连接数据库

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
import java.sql.*;
/**
 *
 * @author HP
 */
public class Conn {

    /**
     * @param args the command line arguments
     */
    //static Statement sql;
    static Connection con;
    static PreparedStatement sql;
    static ResultSet res;
    
    public Connection getConnection()
    {
        try
        {
            Class.forName("com.mysql.cj.jdbc.Driver"); 
            System.out.println("数据库驱动加载成功");
        }
        catch(ClassNotFoundException e)
        {
            e.printStackTrace();
        }
        //用于加载数据库驱动程序
        
        try
        {
            con=DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql?&useSSL=false&serverTimezone=UTC", "root", "");
            System.out.println("数据库连接成功");
        }
        catch(SQLException e)
        {
            e.printStackTrace();
        }
        //用于连接数据库，建立连接数据库的Connection对象,每次访问都需要建立一个对象
        
        
        return con;
    }
    
    
    
    public static void main(String[] args) {
        // TODO code application logic here
        Conn co=new Conn();
        co.getConnection();   //调用函数与数据库建立联系
        
        try
        {
            //sql=con.createStatement(); //实例化Statement对象
            
            //执行sql语句，对数据库操作，并返回结果集
            //res=sql.executeQuery("select * from company.employee");
            
            /*sql=con.prepareStatement("select * from company.employee");
            res=sql.executeQuery();
            
            //遍历查询结果
            while(res.next())
            {
                int id = res.getInt("id");
                String name = res.getString("name");
                int age = res.getInt("age");
                String sex = res.getString("sex");
                System.out.print("id:"+id+"\t");
                System.out.print("name:"+name+"\t");
                System.out.print("age:"+age+"\t");
                System.out.println("sex:"+sex+"\t");
                
            }*/
        
        
        
        //预处理添加数据
        //添加数据
        sql=con.prepareStatement("insert into company.employee values(?,?,?,?)");
        sql.setInt(1, 13);
        sql.setString(2, "mm");
        sql.setInt(3,97);
        sql.setString(4, "male");
        sql.executeUpdate();
        
        
        
        //查看改后的表
        sql=con.prepareStatement("select * from company.employee");
        res=sql.executeQuery();
        System.out.println("改后的数据：");
        while(res.next())
            {
                int id = res.getInt("id");
                String name = res.getString("name");
                int age = res.getInt("age");
                String sex = res.getString("sex");
                System.out.print("id:"+id+"\t");
                System.out.print("name:"+name+"\t");
                System.out.print("age:"+age+"\t");
                System.out.println("sex:"+sex+"\t");
                
            }
        }
        
        catch(Exception e)
        {
            e.printStackTrace();
        }
    }
    
}