Java连接数据库，实现增删改查

第0步，需要添加jar包

Java 连接 MySQL 需要驱动包，最新版下载地址为：http://dev.mysql.com/downloads/connector/j/，解压后得到jar库文件，然后在对应的项目中导入该库文件。

1.增加元素String sql="insert into s_table values (?,?,?,?)";

package com.java.jf.水果库存系统;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.Scanner;

public class Test {
	public static void main(String []args) {
		Scanner input=new Scanner(System.in);
		System.out.print("请输入学号:");
		String sid=input.next();
		System.out.print("请输入姓名");
		String sname=input.next();
		System.out.print("请输入年龄:");
		int age=input.nextInt();
		System.out.print("请输入备注：");
		String remark=input.next();
		try {
			//加载驱动
			Class.forName("org.gjt.mm.mysql.Driver");
			//通过驱动管理器获取连接对象
			Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/0222db", "root","123456");
			//编写SQL语句
			String sql="insert into s_table values (?,?,?,?)";
			//创建预处理命令对象
			PreparedStatement psmt=conn.prepareStatement(sql);
			//填充参数
			psmt.setString(1, sid);
			psmt.setString(2, sname);
			psmt.setInt(3, age);
			psmt.setString(4, remark);
			//执行更新
			int count =psmt.executeUpdate();
			System.out.println(count>0?"更新成功":"更新失败！");
			
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
	}

}

2.更改某项的数值String sql="update s_table set age=? , remark=? where sid=? ";

package com.java.jf.fruit;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.Scanner;

public class Test {

	public static void main(String[] args) {
		Scanner input=new Scanner(System.in);
		System.out.print("请输入需要更改人的学号:");
		String sid=input.next();
		System.out.print("请输入修改后年龄:");
		int age=input.nextInt();
		System.out.print("请输入修改的备注：");
		String remark=input.next();
		try {
			//加载驱动
			Class.forName("org.gjt.mm.mysql.Driver");
			//通过驱动管理器连接对象
			Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/0222db", "root", "123456");
			//编写SQL语句
			String sql="update s_table set age=? , remark=? where sid=? ";
			//创建预处理命令对象
			PreparedStatement psmt=conn.prepareStatement(sql);
			//填充参数
			psmt.setInt(1, age);
			psmt.setString(2, remark);
			psmt.setString(3, sid);
			//执行更新
			int count =psmt.executeUpdate();
			System.out.println(count>0?"更新成功":"更新失败");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
	}

}

3.删除某一个记录String sql="delete from s_table where sid=? ";

package com.java.jf.fruit;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.Scanner;

public class Demo01 {

	public static void main(String[] args) {
		Scanner input=new Scanner(System.in);
		System.out.print("请输入需要删除的学号:");
		String sid=input.next();
		try {
			//加载驱动
			Class.forName("org.gjt.mm.mysql.Driver");
			//通过驱动管理器连接对象
			Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/0222db", "root", "123456");
			//编写SQL语句
			String sql="delete from s_table where sid=? ";
			//创建预处理命令对象
			PreparedStatement psmt=conn.prepareStatement(sql);
			//填充参数
			psmt.setString(1, sid);
			//执行更新
			int count =psmt.executeUpdate();
			System.out.println(count>0?"更新成功":"更新失败");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

}

4.查询

package com.java.jf.fruit;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

public class Demo02 {

	public static void main(String[] args) {
		List <Student> list=new ArrayList<Student>();
		
		try {
			Class.forName("org.gjt.mm.mysql.Driver");
			Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/0222db", "root", "123456");
			String sql="select * from s_table";
			PreparedStatement psmt=conn.prepareStatement(sql);
			//执行查询
			ResultSet rs=psmt.executeQuery();
			while(rs.next()) {
				String sid=rs.getString(1);
				String sname=rs.getString(2);
				int age=rs.getInt(3);
				String remark =rs.getString(4);
				
				Student stu=new Student();
				stu.sid=sid;
				stu.sname=sname;
				stu.age=age;
				stu.remark=remark;
				
				list.add(stu);
			}
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
		for(int i=0;i<list.size();i++) {
			Student stu=list.get(i);
			stu.showInfo();
		}

	}

}

5.查询特定

package com.java.jf.fruit;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Scanner;

public class Demo02 {

	public static void main(String[] args) {
		Scanner input=new Scanner(System.in);
		System.out.print("请输入学号");
		String sid=input.next();
		try {
			Class.forName("org.gjt.mm.mysql.Driver");
			Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/0222db", "root", "123456");
			String sql="select * from s_table where sid=?";
			PreparedStatement psmt=conn.prepareStatement(sql);
			psmt.setString(1, sid);
			//执行查询
			ResultSet rs=psmt.executeQuery();
			if(rs.next()) {
				String sname=rs.getString(2);
				int age=rs.getInt(3);
				String remark =rs.getString(4);
				
				Student stu=new Student();
				stu.sid=sid;
				stu.sname=sname;
				stu.age=age;
				stu.remark=remark;
				
				stu.showInfo();
			}
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}