JDBC程序2:增插入、改、删

来源：互联网发布：windows 10 ie修复编辑：程序博客网时间：2024/05/29 18:59

package com.jikexueyuan.jdbc;

import java.sql.Statement;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

public class JDBCTest{

publicstatic ConnectiongetConnection(){

Connection conn = null;

try {

Class.forName("com.mysql.jdbc.Driver");//注册驱动程序；Class为封装：jvm中类的信息

conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/jsp_db","root", "");//获取数据库的连接:url 用户名密码

//jsp_db为数据库软件中创建的数据库

}catch (Exception e){

e.printStackTrace();

}

return conn;

}

public staticvoid insert(){

Connection conn= getConnection();

try {

String sql = "INSERT INTO tbl_user(name,password,email)"+

"VALUES('Tom','123456','tom@gmail.com')";

Statement st= conn.createStatement();

int count = st.executeUpdate(sql);

System.out.println("向用户表中插入了"+count+" 条记录");

conn.close();

} catch (Exception e){

e.printStackTrace();

}

public staticvoid update(){

Connection conn= getConnection();

try {

String sql = "UPDATE tbl_user SET email='tom@126.com' WHERE name = 'Tom'";//更改邮箱

Statement st= conn.createStatement();

int count = st.executeUpdate(sql);

System.out.println("向用户表中更新了"+count+" 条记录");

conn.close();

} catch (Exception e){

e.printStackTrace();

}

public staticvoid delete(){

Connection conn= getConnection();

try {

String sql = "DELETE FROM tbl_user WHERE name = 'Tom'";

Statement st= conn.createStatement();

int count = st.executeUpdate(sql);

System.out.println("从用户表中删除了"+count+" 条记录");

conn.close();

} catch (Exception e){

e.printStackTrace();

}

public staticvoid main(String[]args) {

// String sql = "SELECT *FROM tbl_user";

// Connection conn = null;

// Statement st = null;

// ResultSet rs = null;

// try {

// Class.forName("com.mysql.jdbc.Driver");//注册驱动程序；Class为封装：jvm中类的信息

// conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/jsp_db", "root", "");//获取数据库的连接:url 用户名密码

// //jsp_db为数据库软件中创建的数据库

// st = conn.createStatement();

// rs = st.executeQuery(sql);

// while (rs.next()) {

// System.out.print(rs.getInt("id")+" ");

// System.out.print(rs.getString("name")+" ");

// System.out.print(rs.getString("password")+" ");

// System.out.print(rs.getString("email")+" ");

// System.out.println();

// }

// } catch (Exception e) {

// e.printStackTrace();

// }finally{

// try {

// rs.close();

// } catch (Exception e2) {

// }

// try {

// st.close();

// } catch (Exception e3) {

// // TODO: handle exception

// }

// try {

// conn.close();

// } catch (Exception e4) {

// // TODO: handle exception

// }

//insert();

//update();

delete();

}

0 0