java-jdbc-MySQL

留作备份

考虑这学期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);
		}
	}
}