jdbc使用

jdbc使用

package com.rocket.framework.practice.jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.UUID;

public class JDBCTest {
	
	public static String URL = "jdbc:mysql://localhost:3306/paperanalyse";
	
	public static String USER = "root";
	
	public static String PASSWORD = "root";

	public static void main(String[] args) {
		testJDBC();
	}
	
	public static void testJDBC() {
		try {
			//加载驱动
			Class.forName("com.mysql.jdbc.Driver");
			
			//连接数据库
			Connection con = DriverManager.getConnection(URL, USER, PASSWORD);
			
			Statement stat = con.createStatement();
			
			String uid = UUID.randomUUID().toString();
			
			String name = "wang";
			
			String studentNum = "2014";
			
			String sex = "男";
			
			String insertSQL = "insert into student values('" + uid + "', '" + name + "' ,'" + studentNum + "', '" + sex + "')";
			
			int count = stat.executeUpdate(insertSQL);
			
			System.out.println(count);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e1) {
			e1.printStackTrace();
		}
	}

}