ResultSet rs=null;try{//1.获取数据库连接conn =JDBCUtils.getConnection();//2.定义SQL---拼接---String sql = "select * from user where username='" + username + "' and password ='" + password + "' ";//3.获取执行SQL的对象stmt =conn.createStatement();//4.执行查询rs =stmt.executeQue...
不用再拼接这种方式了(拼接有坏处：1、不易读 2、可能会发生SQL注入问题)
String sql = "select id from t_user order by id + '"+keyWords+"';";
JDBC 2019-12-11 16:24 − 题目一:编写一个应用程序,输入用户名和密码,访问test数据库中t_login表(字段包括id、username、password),验证登录是否成功。代码: Test.java 1 package cn.edu.ccut; 2 import java.sql.*; 3 import j... chris丶w 0 456 JDBC 2019-12-10 17:33 − JDBC——jav...
ResultSet rs=null;try{//1.获取数据库连接conn =JDBCUtils.getConnection();//2.定义SQL---拼接---String sql = "select * from user where username='" + username + "' and password ='" + password + "' ";//3.获取执行SQL的对象stmt =conn.createStatement();//4.执行查询rs =stmt.executeQue...