2021-01-18

package db;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ResourceBundle;
import java.sql.Statement;

public class test3 {
	public static void main(String[] args) {
		// JDBC 对 DQL语句的操作
		new test3().jdbcDql();
	}

	ResourceBundle rb = ResourceBundle.getBundle("db.JDBC");
	String driver = rb.getString("driver");
	String url = rb.getString("url");
	String user = rb.getString("user");
	String pass = rb.getString("pass");

	public void jdbcDql() {

		// 1 -加载驱动
		try {
			Class.forName(driver);
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		Connection conn = null;
		Statement st = null;
		ResultSet rs = null;
		// String sql = "select s_id,s_name,s_age,s_sex from student ";
		
		//String sql = "insert into  student (s_id,s_name,s_age,s_sex) values(?,?,?,?)";
		   String  sql  ="update student  set s_name=?,s_age=?,s_sex=? where s_id=?";
		   
		int result = -1;
		try {
			// 2获得链接
			conn = DriverManager.getConnection(url, user, pass);
			// 3 获得状态集
			// st = conn.createStatement();
			// 4 执行DQL 返回结果集
			// rs = st.executeQuery(sql);
			//st = conn.prepareStatement(sql);
			// 3- 获得预处理的状态集
			PreparedStatement ps = conn.prepareStatement(sql);
			//它替换的就是问号 里面的类型
			
			ps.setString(1, "pij四");
			ps.setString(2, "1991-12-01 00:00:00" );
			ps.setString(3, "男");
			ps.setInt(4,8);
			//  赋值不能赋多了 也 不能赋少了
			// 没有参数
			result = ps.executeUpdate();
			System.out.println(result);
			//得到结果集
			rs=ps.executeQuery();
			while (rs.next()) {

				String sId = rs.getString(1);
				String sName = rs.getString(2);
				String sAge = rs.getString(3);
				String sSex = rs.getString(4);
				// String sId = rs.getString("s_id");
//				String sName = rs.getString("s_name");
//				String sAge = rs.getString("s_age");
//				String  sSex = rs.getString("s_sex");
				System.out.println(sId + "" + sName + "" + sAge + "" + sSex);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {

			if (rs != null) {
				try {
					rs.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				rs = null;
			}

			if (st != null) {
				try {
					st.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				st = null;
			}
			if (conn != null) {
				try {
					conn.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				conn = null;
			}

		}

	}
}