mysql带参数的查询_带参数的数据查询

Util.java

import java.sql.*;

public class Util {

private Connection conn;

private Statement stm;

private ResultSet rs;

private String classname="com.mysql.jdbc.Driver";

private String url="jdbc:mysql://localhost:3306/test";

public Util(){

try {

Class.forName(classname);

} catch (ClassNotFoundException e) {

e.printStackTrace();

}

}

/*获取连接*/

public Connection getConn() {

try {

conn=DriverManager.getConnection(url,"root","123456");

} catch (SQLException e) {

e.printStackTrace(System.err);

conn=null;

}

return conn;

}

/*关闭连接*/

public void closed(){

try {

if (rs!=null) {

rs.close();

}

if (stm!=null) {

stm.close();

}

if(conn!=null){

conn.close();

}

} catch (SQLException e) {

e.printStackTrace();

}

}

public void setConn(Connection conn) {

this.conn = conn;

}

/*执行语句*/

public Statement getStm() {

try {

conn=getConn();

stm=conn.createStatement();

} catch (SQLException e) {

e.printStackTrace();

}

return stm;

}

public Statement getStmed(){

try {

conn=getConn();

stm=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);

} catch (SQLException e) {

e.printStackTrace();

}

return stm;

}

public ResultSet getAllRs(){

String sql="select * from u";

try {

stm=getStmed();

rs=stm.executeQuery(sql);

} catch (SQLException e) {

e.printStackTrace();

}

return rs;

}

public ResultSet getPartRs(String subsql,String subsqlvalue){

if(subsql==null){

subsql="";

}

if(subsqlvalue==null){

subsqlvalue="";

}

String sql= "select * from u where "+subsql+" ='"+subsqlvalue+"'";

try {

stm=getStmed();

rs=stm.executeQuery(sql);

} catch (SQLException e) {

e.printStackTrace();

}

return rs;

}

index.jsp

Id

用户名

密码

ResultSet rsall = db.getAllRs();

while(rsall.next()){

%>

}

%>

查询类型：

Id

用户名

密码

生成的版权信息

result.jsp

ResultSet rs = null;

boolean mark=true;

String mess="";

String subsql= request.getParameter("subsql");

String subsqlvalue=request.getParameter("subsqlvalue");

%>

Id	用户名	密码

rs=db.getPartRs(subsql, subsqlvalue);

if(!rs.next()){

%>

没有记录显示！

}else{

rs.previous();

while(rs.next()){

%>

}

}

%>

3.PNG

4.PNG