JAVA连接mysql简单例子

一．程序说明
使用java连接mysql数据库，实现insert,delete,update,select基本功能。数据库名为student,表名为student，所有操作均在student表上操作。
二．主要步骤

1. 加载驱动
   Class.forName(JDBC_DRIVER);
2. 连接数据库
   Connection conn = DriverManager.getConnection(DB_URL,USER,PASS);
3. 实例化Statement对象
   Statement stmt = conn.createStatement();
4. 执行查询
   String sql;
   sql = “此处为sql查询语句”;
   ResultSet rs = stmt.executeQuery(sql);
5. 使用Statement对象执行静态SQL语句，增，删，改
   int executeUpdate(String sql)
   用于执行SQL中的insert，update，delete语句。
6. 显示查询结果
   System.out.println(“±-----±------------±-----±------+”);
   System.out.println("| name | code | age | class |");
   System.out.println(“±-----±------------±-----±------+”);
   while (rs.next()) {
   System.out.println("| “+rs.getString(“name”)+” | “+rs.getString(“code”)+” | “+rs.getString(“age”)+” | “+rs.getString(“class”)+” |");
   }
   System.out.println(“±-----±------------±-----±------+”);源程序
   三．源程序

import java.sql.*;

public class MysqlJdbc {

	public static void main(String[] args) {
		try {
			Class.forName("com.mysql.jdbc.Driver");     //加载MYSQL JDBC驱动程序   
			System.out.println("JDBC驱动程序加载成功");
		}
		catch (Exception e) {
			System.out.print("JDBC驱动程序加载失败");
			e.printStackTrace();
		}
		try {
			//连接数据库
			Connection connect = DriverManager.getConnection(
					"jdbc:mysql://localhost:3306/student","root","123");
			System.out.println("成功连接数据库");
			Statement stmt = connect.createStatement();
			//开始时查询结果
			ResultSet rs = stmt.executeQuery("select * from student;");
			System.out.println("开始时查询结果为：");
			System.out.println("+------+-------------+------+-------+");
			System.out.println("| name | code        | age  | class |");
			System.out.println("+------+-------------+------+-------+");
			while (rs.next()) {
				System.out.println("| "+rs.getString("name")+"  | "+rs.getString("code")+" | "+rs.getString("age")+"   | "+rs.getString("class")+"     |");
			}
			System.out.println("+------+-------------+------+-------+");
			
			//增加一条记录后查询结果
			System.out.println("增加一条记录后查询结果为：");
			stmt.executeUpdate("insert into student values('lhk','19999999999','19','7');");
			rs = stmt.executeQuery("select * from student");
			System.out.println("+------+-------------+------+-------+");
			System.out.println("| name | code        | age  | class |");
			System.out.println("+------+-------------+------+-------+");
			while (rs.next()) {
				System.out.println("| "+rs.getString("name")+"  | "+rs.getString("code")+" | "+rs.getString("age")+"   | "+rs.getString("class")+"     |");
			}
			System.out.println("+------+-------------+------+-------+");
			
			//修改name为"lhk"学生的学号为"17401070733"
			System.out.println("修改name为lhk学生的学号为17401070733后查询结果为：");
			stmt.executeUpdate("update student set code='17401070733' where name='lhk';");
			rs = stmt.executeQuery("select * from student");
			System.out.println("+------+-------------+------+-------+");
			System.out.println("| name | code        | age  | class |");
			System.out.println("+------+-------------+------+-------+");
			while (rs.next()) {
				System.out.println("| "+rs.getString("name")+"  | "+rs.getString("code")+" | "+rs.getString("age")+"   | "+rs.getString("class")+"     |");
			}
			System.out.println("+------+-------------+------+-------+");
			
			//删除name为"lhk"的学生记录
			System.out.println("删除name为lhk的学生记录后查询结果为：");
			stmt.executeUpdate("delete from student where name='lhk';");
			rs = stmt.executeQuery("select * from student");
			System.out.println("+------+-------------+------+-------+");
			System.out.println("| name | code        | age  | class |");
			System.out.println("+------+-------------+------+-------+");
			while (rs.next()) {
				System.out.println("| "+rs.getString("name")+"  | "+rs.getString("code")+" | "+rs.getString("age")+"   | "+rs.getString("class")+"     |");
			}
			System.out.println("+------+-------------+------+-------+");
		}
		catch (Exception e) {
			System.out.print("get data error!");
			e.printStackTrace();
		}
	}

}

四．运行过程截图
1.加载驱动并连接数据库

2.查询student数据库中student表所有内容

3.增加student表中一条记录

4.修改student表中某记录的值

5.删除student表中的一条记录