发布网友 发布时间:2022-04-26 23:32
共2个回答
热心网友 时间:2022-04-07 20:31
PreparedStatement热心网友 时间:2022-04-07 21:49
增删改查都有链接网页链接
粘贴着查询的:
package cn.web.jdbc;
import java.sql.*;
public class UserLogin {
public static void main(String[] args) {
// 加载驱动
try {
Class.forName("com.mysql.jdbc.Driver");
// 获取连接
String url = "jdbc:mysql://localhost:3306/usejdbc?useUnicode=true&characterEncoding=UTF-8&useSSL=false";
String user = "root";
String mysqlPassword = "123456";
//模拟前台传入的用户名和密码
String InputUsername = "老八";
String InputPassword = "123456";
try {
// 连接对象输入三个参数
Connection connection = DriverManager.getConnection(url, user, mysqlPassword);
System.out.println(connection);
//定义sql语句
// 查询
String sql1 = "select * from student where username='" + InputUsername + "' and password='" + InputPassword + "'";
System.out.println(sql1);
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery(sql1);
System.out.println(resultSet);
if (resultSet.next()) {
System.out.println("登录成功");
} else {
System.out.println("登录失败");
}
// 释放资源
statement.close();
connection.close();
resultSet.close();
} catch (SQLException e) {
e.printStackTrace();
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
}