JDBC:Java操作MySql代码！（不用工具类）

package JdbcUtil;

import java.security.PublicKey;
import java.sql.*;

public class App2 {
    static Connection connection;
    public static void main(String[] args) throws Exception {
        getConnection("com.mysql.jdbc.Driver",
				//根据情况更改：主机名和端口号
                "jdbc:mysql://master:3306/test1?useUnicode=true&characterEncoding=utf-8",
                "root",
                "123456");
		//createStu();
        //addStu(1001,"李宁","男","1234","2019-09-09","中国");
        //updateStu(1001,"李四","女","1234","2019-09-09","上海");
        //deletetu(1001);
        selectStu();
    }
	//创建表
    public static void createStu() throws SQLException {
        String sql="create table student(id INT(5),name VARCHAR(20),gender VARCHAR(20),pwd VARCHAR(20),birthdate VARCHAR(20),addr VARCHAR(20))";
        Statement statement=connection.createStatement();
        int i =statement.executeUpdate(sql);
        if (i=0){
            System.out.println("创建表成功");
        }else{
            System.out.println("创建表失败");
        }
    }
    //创建JDBC连接的方法
    public static void getConnection(String driver,String url,String username,String password) throws Exception {
        //加载驱动包
        Class.forName(driver);
        //获取连接对象
        connection= DriverManager.getConnection(url,username,password);
        System.out.println("连接创建成功");
    }
    //插入数据
   public static void addStu(int id, String name,String gender,String pwd,String birthdate,String addr) throws SQLException {
       //String sql="insert into student(id,name,gender,pwd,birthdate,addr) values(?,?,?,?,?,?)";
        String sql="insert into student values("+id+",'"+name+"','"+gender+"','"+pwd+"','"+birthdate+"','"+addr+"')";
        Statement statement=connection.createStatement();
        int i =statement.executeUpdate(sql);
        if (i>0){
            System.out.println("插入数据成功");
        }else{
            System.out.println("插入数据失败");
        }
    }
    //修改数据
    public static void updateStu(int id, String name,String gender,String pwd,String birthdate,String addr) throws SQLException {
        String sql="update student set name ='"+name+"',gender='"+gender+"'where id="+id+"";
        Statement statement=connection.createStatement();
        int i =statement.executeUpdate(sql);
        if (i>0){
            System.out.println("修改数据成功");
        }else{
            System.out.println("修改数据失败");
        }
    }
    //删除数据
    public static void deletetu(int id) throws SQLException {
        String sql="delete from student where id="+id+"";
        Statement statement=connection.createStatement();
        int i =statement.executeUpdate(sql);
        if (i>0){
            System.out.println("删除数据成功");
        }else{
            System.out.println("删除数据失败");
        }
    }
    //查询数据
    public static void selectStu() throws SQLException {
        String sql="select * from student";
        PreparedStatement ps=connection.prepareStatement(sql);
        ResultSet resultSet=ps.executeQuery();
        //解析Resule，和迭代器类似
        while (resultSet.next()){
            System.out.println("id:"+resultSet.getInt("id")+
                    ",name:"+resultSet.getString("name")+
                    ",gender:"+resultSet.getString("gender")+
                    ",pwd:"+resultSet.getString("pwd")+
                    ",birthdate:"+resultSet.getString("birthdate")+
                    ",addr:"+resultSet.getString("addr"));
        }
    }
}