package com.hspedu.jdbc;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.sql.*;
import java.util.Properties;
import java.util.Scanner;
/**
* @author: guorui fu
* @versiion: 1.0
*/
public class jdbcPreparedStatement {
public static void main(String[] args) throws Exception {
Scanner scanner = new Scanner(System.in);
// System.out.println("输入用户名");
// String admin_name = scanner.nextLine();
// System.out.println("输入用户密码");
// String admin_password = scanner.nextLine();
Properties properties = new Properties();
properties.load(new FileInputStream("src\\mysql.properties"));
String user = properties.getProperty("user");
String password = properties.getProperty("password");
String url = properties.getProperty("url");
String driver = properties.getProperty("driver");
Class.forName(driver);
Connection connection = DriverManager.getConnection(url, user, password);
String sql = "select * from admin";
PreparedStatement preparedStatement = connection.prepareStatement(sql);
// preparedStatement.setString(1,admin_name);
// preparedStatement.setString(2,admin_password);
// int row = preparedStatement.executeUpdate();
// System.out.println(row > 0 ? "执行成功":"执行失败");
ResultSet resultSet = preparedStatement.executeQuery();
while(resultSet.next()){
String name = resultSet.getString(1);
String passwords = resultSet.getString(2);
System.out.println( name + "\t" + passwords);
}
}
}
JDBC 预处理PreparedStatement
最新推荐文章于 2024-06-14 14:08:37 发布