增删改查sql语言

Add.java
package jdbc;
import java.util.Scanner;
import java.sql.*;


public class Add {

    public static void main(String[] args) throws Exception {
       // Class.forName("com.mysql.jdbc.Driver");//加载驱动
        Scanner sc = new Scanner(System.in);
        String jdbc="jdbc:mysql://127.0.0.1:3306/mydb?characterEncoding=GBK";
        Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/world", "root", "1767737316.");//链接到数据库
        Statement state=conn.createStatement(); 
        String stunumber;
        String stuname;
        int stuscore;
        System.out.println("请输入学号");
        stunumber = sc.nextLine();
        System.out.println("姓名");
        stuname = sc.nextLine();
        System.out.println("成绩");
        stuscore = sc.nextInt();
        String sql = "insert into 博哥战神(number,name,score) values(?,?,?)";   //SQL语句
        PreparedStatement presta = conn.prepareStatement(sql);
                     // 设置sql语句中的values值
                     presta.setString(1,stunumber);
                     presta.setString(2,stuname);
                     presta.setInt(3,stuscore);
        int count = presta.executeUpdate(sql);        System.out.println(count);
        conn.close();//关闭通道

    }
}
增删改查sql语言

推荐阅读
