JDBC基础

DBTool.java

package util;

import java.sql.*;

public class DBTool {

	static Connection conn = null;
	static String driverClass = "com.mysql.jdbc.Driver";
	static String url = "jdbc:mysql://localhost:3306/stu";
	static String username = "root";
	static String password = "root";
	
	public static Connection getConn(){
		try {
			Class.forName(driverClass);
			conn = DriverManager.getConnection(url,username,password);
		} catch(Exception e){
			e.getMessage();
		}
		return conn;
	}
	
	public static void close(){
		try {
			if (conn != null){
				conn.close();
			}
		} catch(Exception e){
			e.getMessage();
		}
	}
}

Student.java

package model;

public class Student {

	private String id;
	private String sname;
	private int age;
	
	public Student() {
		
	}
	
	public Student(String id, String sname, int age) {
		this.id = id;
		this.sname = sname;
		this.age = age;
	}
	
	public void setId(String id) {
		this.id = id;
	}
	
	public void setSname(String sname) {
		this.sname = sname;
	}
	
	public void setAge(int age) {
		this.age = age;
	}
	
	public String getId() {
		return id;
	}
	
	public String getSname() {
		return sname;
	}
	
	public int getAge() {
		return age;
	}
}

StudentDao.java

package dao;
import java.sql.*;
import util.DBTool;
import model.Student;

public class StudentDao {
	
	private Student student = null;
	
	public static int addStudent(Student student) {
		int result = 0;
		PreparedStatement ps = null;
		String sql = "insert into student(id,sname,age) values(?,?,?)";
		try {
			ps = DBTool.getConn().prepareStatement(sql);
			ps.setString(1,student.getId());
			ps.setString(2,student.getSname());
			ps.setInt(3,student.getAge());
			result = ps.executeUpdate();
		} catch(Exception e){
			e.getMessage();
		}
		return result;
	}
	
	public static ResultSet getUser(String id){
		ResultSet rs = null;
		PreparedStatement ps = null;
		String sql = "select (id,sname,age) from student where id = ?";
		try {
			ps = DBTool.getConn().prepareStatement(sql);
			ps.setString(1, id);
			rs = ps.executeQuery();
		} catch(Exception e){
			e.getMessage();
		}
		return rs;
	}
	
}

StudentService.java

package service;

import java.sql.*;
import model.Student;
import dao.StudentDao;
import java.util.Scanner;

public class StudentService {

	public static void main(String[] args){
		StudentDao studentDao = new StudentDao();
		Scanner sc = new Scanner(System.in);
		System.out.print("input style");
		String sty = sc.next();
		if(sty.equals("add")) {
			System.out.println("please input id");
			String id = sc.next();
			System.out.println("please input sname");
			String sname = sc.next();
			System.out.println("please input age");
			int age = sc.nextInt();
			Student student = new Student();
			student.setId(id);
			student.setSname(sname);
			student.setAge(age);
			if(studentDao.addStudent(student) > 0){
				System.out.println("insert success~");
			}
		} else if(sty.equals("select")){
			System.out.println("please input id");
			String id = sc.next();
			ResultSet rs = studentDao.getUser(id);
			
			try {
				while(rs.next()){
					String uid = rs.getString(1);
					String sname = rs.getString(2);
					int age = rs.getInt(3);
					System.out.println(uid + "--" + sname + "--" + age + "\n");
				}
			} catch(Exception e){
				e.getMessage();
			}
		}
	}
}

 

Java项目目录结构：
-src
 -model
  -Student.java
 -dao
  -StudentDao.java
 -util
  -DBTool.java
 -service
  -StudentService.java

如有疑问，联系QQ：553340463