• jdbc 数据库的连接 以及数据库的增删改查


    //加载驱动

    //连接数据库

    //sql语句

    //创建执行SQL语句的Statement对象

    //处理sql语句执行的结果集(ResultSet)

    package util;

    import java.sql.Connection;
    import java.sql.DriverManager;

    public class Jdbcutil {
    private static Connection conn=null;
    static{
    String url="jdbc:mysql://localhost:3306/test";
    String username="root";
    String password="1234";
    String driverClass="com.mysql.jdbc.Driver";


    try {Class.forName(driverClass);//
    conn = DriverManager.getConnection(url, username, password); //
    } catch (Exception e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
    }
    }
    public static Connection getConnection(){

    if(conn!=null){
    return conn;
    }
    else {
    return null;
    }

    }

    }

    查询

    public List<Student> getStudentList(){

    PreparedStatement preparedStatement=null;
    ResultSet rs=null;
    List<Student> studentlist=new ArrayList<Student>();
    Connection connection=Jdbcutil.getConnection();
    String sql="select * from student";
    try {
    preparedStatement=connection.prepareStatement(sql);
    } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
    }
    try {
    rs = preparedStatement.executeQuery();
    while (rs.next()) {
    Student student=new Student();
    int id=rs.getInt("id");
    String name=rs.getString("name");
    String school=rs.getString("school");
    double score=rs.getDouble("score");
    student.setId(id);
    student.setName(name);
    student.setSchool(school);
    student.setScore(score);
    studentlist.add(student);

    }
    } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
    }


    return studentlist;}

    增删改

    public void tianjia(String userid,String username,String userschool,String userscore){
    PreparedStatement preparedStatement=null;
    Connection connection=Jdbcutil.getConnection();
    String sql="insert into student values (?,?,?,?)";
    try {
    preparedStatement=connection.prepareStatement(sql);
    preparedStatement.setObject(1, userid);
    preparedStatement.setObject(2, username);
    preparedStatement.setObject(3, userschool);
    preparedStatement.setObject(4, userscore);
    preparedStatement.executeUpdate();

    } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
    }

    }

    public void shanchu(String userid){
    PreparedStatement preparedStatement=null;
    Connection connection=Jdbcutil.getConnection();
    String sql="DELETE FROM student WHERE id='"+userid+"'";
    try {
    preparedStatement=connection.prepareStatement(sql);
    preparedStatement.executeUpdate();

    } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
    }

    }

    public void xiugai(String userid,String username,String userschool,String userscore){
    PreparedStatement preparedStatement=null;
    Connection connection=Jdbcutil.getConnection();
    String sql="update student set id=?,name=?,school=?,score=? where id='"+userid+"'";
    try {
    preparedStatement=connection.prepareStatement(sql);
    preparedStatement.setObject(1, userid);
    preparedStatement.setObject(2, username);
    preparedStatement.setObject(3, userschool);
    preparedStatement.setObject(4, userscore);
    preparedStatement.executeUpdate();

    } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
    }

    }

  • 相关阅读:
    SQL性能优化:如何定位网络性能问题
    ORACLE 10升级到10.2.0.5 Patch Set遇到的内核参数检测失败问题
    Linux 僵尸进程查杀
    Linux 虚拟机网络适配器从E1000改为VMXNET3
    v$session中server为none与shared值解析
    SQL SERVER导出特殊格式的平面文件
    XtraBackup出现 Can't connect to local MySQL server through socket '/tmp/mysql.sock'
    CentOS 6.6安装Xtrabackup RPM提示缺少libev.so.4()
    SQL Server Replication 中关于视图的点滴
    ORA-00988: missing or invalid password(s)
  • 原文地址:https://www.cnblogs.com/zhaosong-0102/p/7355494.html
Copyright © 2020-2023  润新知