import javax.swing.*;
import com.mysql.jdbc.Statement;
import java.awt.*; //导入必要的包
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
public class Test extends JFrame {
public boolean hasResult(String name, String password) throws ClassNotFoundException, SQLException {
final String driverClassNanme = "com.mysql.jdbc.Driver";
final String URL = "jdbc:mysql://localhost:3306/db_conn";
// 数据库路径:服务器所在的计算机为localhost:1433;
// 数据库名称:UserInfo
final String UserName = "root"; // 用户名称
final String PassWord = "123456"; // 用户密码
Class.forName("com.mysql.jdbc.Driver"); // 加载驱动程序
Connection conn = DriverManager.getConnection(URL, UserName, PassWord); // 创建数据库连接
Statement statement = (Statement) conn.createStatement();
// 要执行的SQL语句
String sql = "select * from db_student where name='" + name + "' and password = '" + password + "'";
// 3.ResultSet类,用来存放获取的结果集!!
ResultSet rs = statement.executeQuery(sql);
if (rs != null) {
return true;
}
return false;
}
}
import com.mysql.jdbc.Statement;
import java.awt.*; //导入必要的包
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
public class Test extends JFrame {
public boolean hasResult(String name, String password) throws ClassNotFoundException, SQLException {
final String driverClassNanme = "com.mysql.jdbc.Driver";
final String URL = "jdbc:mysql://localhost:3306/db_conn";
// 数据库路径:服务器所在的计算机为localhost:1433;
// 数据库名称:UserInfo
final String UserName = "root"; // 用户名称
final String PassWord = "123456"; // 用户密码
Class.forName("com.mysql.jdbc.Driver"); // 加载驱动程序
Connection conn = DriverManager.getConnection(URL, UserName, PassWord); // 创建数据库连接
Statement statement = (Statement) conn.createStatement();
// 要执行的SQL语句
String sql = "select * from db_student where name='" + name + "' and password = '" + password + "'";
// 3.ResultSet类,用来存放获取的结果集!!
ResultSet rs = statement.executeQuery(sql);
if (rs != null) {
return true;
}
return false;
}
}