java操作mysql数据库

package shine;
import java.sql.*;

public class mysqllearn {
	private String url  = "jdbc:mysql://localhost/cjkcb";
	private String user = "root";
	private String pwd  = "123456";
	
	public static void main(String[] args){
		mysqllearn myAct = new mysqllearn();
		try{
			Class.forName("com.mysql.jdbc.Driver").newInstance();
			Connection conn = DriverManager.getConnection(myAct.url, myAct.user, myAct.pwd);
			Statement stmt  = conn.createStatement();
			ResultSet rs    = stmt.executeQuery("SELECT * FROM academy");
			while(rs.next()){
				String name  = rs.getString("name");
				int schoolId = rs.getInt("schoolId");
				System.out.println(name+"的schoolId:"+schoolId);
			}
			rs.close();
			conn.close();
		}catch(Exception ex){
			System.out.println("Error:"+ex.toString());
		}
	}
}

package shine;
import java.sql.*;

public class mysqllearn {
	private String url  = "jdbc:mysql://localhost/cjkcb?useUnicode=true&characterEncoding=utf8";
	private String user = "root";
	private String pwd  = "123456";
	
	public static void main(String[] args){
		mysqllearn myAct = new mysqllearn();
		try{
			Class.forName("com.mysql.jdbc.Driver").newInstance();
			Connection conn = DriverManager.getConnection(myAct.url, myAct.user, myAct.pwd);
			Statement stmt  = conn.createStatement();
			stmt.executeUpdate("INSERT INTO academy(id, name, schoolId) VALUES('5','华南理工大学', '10011')");
			stmt.close();
			conn.close();
		}catch(Exception ex){
			System.out.println("Error:"+ex.toString());
		}
	}
}