JDBC初步_增删改查

来源：互联网发布：阿里云试用服务器编辑：程序博客网时间：2024/06/10 21:05

驱动&连接数据库
package TextText;

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

public class JDBC {
Connection conn = null;

static {    try {        Class.forName("com.mysql.jdbc.Driver");    } catch (ClassNotFoundException e) {        e.printStackTrace();    }}public Connection openConnection(){    String url = "jdbc:mysql://192.168.11.122:3306/mashensoft";    String user = "user01";    String password = "user01";    try {        conn = DriverManager.getConnection(url, user, password);    } catch (SQLException e) {        e.printStackTrace();    }    return conn;}public void closeConnection(){    if(conn != null){        try {            conn.close();        } catch (SQLException e) {            e.printStackTrace();        }    }}

}

改
package TextText;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class Text {

public static void main(String[] args) {    new Text().updata("700", 4);}public void updata(String str1, int i) {    PreparedStatement pst = null;    String sql = "update java5 set age = ? where id = ?";    JDBC jdbc = new JDBC();    Connection conn = jdbc.openConnection();    try {        pst = conn.prepareStatement(sql);    } catch (SQLException e) {        e.printStackTrace();    }    try {        pst.setString(1, str1);        pst.setInt(2, i);    } catch (SQLException e) {        e.printStackTrace();    }    try {        pst.executeUpdate();    } catch (SQLException e) {        e.printStackTrace();    }}

}

0 0