java-sql学习笔记，用java实现对数据库内容的增删改查。代码一是实现过程。下面一个是一个用来实现上文中的一些方法的类，最后一个文件是用来存储url，classname等内容等待第二个类读取。

// 查找和插入操作
import java.sql.*;
import java.util.Scanner;
//import java.lang.*;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;


public class MySql {
   public static void main(String[] args) {
       //
       Connection conn = null;
       PreparedStatement st = null;
       ResultSet re = null;
       try {
           try {
               //可能会连接失败，所以要用 try catch 的形式
               conn = JdbcUtil.getConnection();
           } catch (Exception e) {
               throw new RuntimeException(e);
           }
           // 增加操作
           //这里的问号是站位符号
           //*****************  **********》》 重点注释 《《************** ********
           //这里的问号是占位符的作用
           // 这里st.setString(1,"valuel") : 意思是第一个占位符师字符串：zhangfei
           // 这里第二行的 st.setString(2,"123456") : 意思是第二个站位符位置的东西
           // 增加用
           // insert into student (name,passwerd) values (?,?)
           String insertSql = "INSERT INTO student (name, password) VALUES (?, ?)";
           st = conn.prepareStatement(insertSql);
           st.setString(1, "zhangfei");
           st.setString(2, "123456");
           // 通过执行下一行的语句实心插入操作
           st.executeUpdate();
           System.out.println("插入成功");

           // 删除操作
           // 删除用
           // delete form student where name = ?
           String deleteSql = "DELETE FROM student WHERE name = ?";
           st = conn.prepareStatement(deleteSql);
           st.setString(1, "zhangfei");
           st.executeUpdate();
           System.out.println("删除成功");

           // 修改操作用
           // update student set password = ? where name = ?
           String updateSql = "UPDATE student SET password = ? WHERE name = ?";
           st = conn.prepareStatement(updateSql);
           st.setString(1, "new_123456");
           st.setString(2, "zhangfei");
           st.executeUpdate();
           System.out.println("修改成功");

           // 查找操作
           // select * from student where name = ?
           String selectSql = "SELECT * FROM student WHERE name = ?";
           st = conn.prepareStatement(selectSql);
           st.setString(1, "zhangfei");
           re = st.executeQuery();
           while (re.next()) {
               System.out.println("name: " + re.getString("name") + ", password: " + re.getString("password"));
           }
       } catch (SQLException e) {
           e.printStackTrace();
       } finally {
           JdbcUtil.release(re, st, conn);
       }

//        Scanner scan = new Scanner(System.in);
//        //connect 接口的作用：获取执行sql语句的对象（总共有三种）
//        Connection conn = null;
//        // 普通执行sql语句的对象
//        // 可以预编译并执行的sql语句的对象：preparedStatement
//        Statement st = null;
//        ResultSet re = null;
//        try {
//            Class.forName("com.mysql.jdbc.Driver");
//            conn = DriverManager.getConnection(url, user, password);
//            st = conn.createStatement();
//            if (conn != null) {
//                System.out.println("success");
//            }
//           String sql = "insert into student (stu_name,stu_password,stu_num) values (\"sb\",\"23234\",88)";
            String sql = "INSERT INTO student (stu_name, stu_password, stu_num) VALUES ('sb', '23432', 55)";
//            boolean re = st.execute(sql);
            while (re.next()) {
                String id = re.getString("stu_name");
                String password = re.getString("stu_password");
                int num = re.getInt("stu_num");
                System.out.println("ID:" + id + ",password:" + password + ",num:" + num);
            }
//            conn.close();
//            st.close();
//
//        } catch (Exception e) {
//            e.printStackTrace();
//        }
    }

}

import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

public class JdbcUtil {
	private static String className;
	private static String url;
	private static String user;
	private static String password;
	static{
		try {
			InputStream in = JdbcUtil.class.getClassLoader().getResourceAsStream("dbinfo.properties");
			Properties props = new Properties();
			props.load(in);
			className = props.getProperty("className");
			url = props.getProperty("url");
			user = props.getProperty("user");
			password = props.getProperty("password");
			Class.forName(className);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	public static Connection getConnection() throws Exception{
		return DriverManager.getConnection(url,user,password);
	}
	public static void release(ResultSet rs,Statement stmt,Connection conn){
		if(rs!=null){
			try {
				rs.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
			rs = null;
		}
		if(stmt!=null){
			try {
				stmt.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
			stmt = null;
		}
		if(conn!=null){
			try {
				conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
			conn = null;
		}
	}
}

以下是一个文档文件 

url=jdbc:mysql://localhost:3306/student
user=root
password=root
Classname=com.mysql.jdbc.Driver