留作备份
考虑这学期java课程设计用数据库jdbc来做
考虑之后写个gui和jdbc的小项目
package com.blank.test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class DbTest {
private static String jdbcName = "com.mysql.jdbc.Driver";
private static String dbUrl = "jdbc:mysql://127.0.0.1:3306/db_test";
private static String dbUserName = "root";
private static String dbUserPass = "";
public static void main(String[] args) {
try {
Class.forName(jdbcName);
System.out.println("加载驱动成功");
Connection conn = DriverManager.getConnection(dbUrl, dbUserName,
dbUserPass);
System.out.println("连接数据库成功");
queryAll(conn);
// instrtData(conn, "孙悟空", "999999");
// queryAll(conn);
// updateData(conn, "11", "唐僧", "77777");
// queryAll(conn);
delData(conn,"孙悟空");
queryAll(conn);
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
// 查询数据
public static void queryAll(Connection conn) {
String sql = "select * from user";
PreparedStatement pre;
try {
pre = conn.prepareStatement(sql);
ResultSet set = pre.executeQuery();
while (set.next()) {
System.out.println(set.getString(1) + " " + set.getString(2)
+ " " + set.getString(3));
}
set.close();
pre.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
// 插入数据
public static void instrtData(Connection conn, String name, String tel) {
try {
String sql = "insert into user values(null,?,?)";
PreparedStatement pre = conn.prepareStatement(sql);
pre.setString(1, name);
pre.setString(2, tel);
pre.executeUpdate();
pre.close();
} catch (Exception e) {
System.out.println(e);
}
}
// 更新数据
public static void updateData(Connection conn, String name, String newName,
String newTel) {
try {
String sql = "update user set name=?,tel=? where name=?";
PreparedStatement pre = conn.prepareStatement(sql);
pre.setString(1, newName);
pre.setString(2, newTel);
pre.setString(3, name);
pre.executeUpdate();
pre.close();
} catch (Exception e) {
System.out.println(e);
}
}
//删除
public static void delData(Connection conn,String name){
try {
String sql = "delete from user where name=?";
PreparedStatement pre = conn.prepareStatement(sql);
pre.setString(1, name);
pre.executeUpdate();
pre.close();
} catch (Exception e) {
System.out.println(e);
}
}
}