调用类DBUtil,select查询
package com.company.Util;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
* 第一:测试DBUtil是否好哦用
*第二:模糊查询怎么写?
* */
public class JDBCTest06 {
public static void main(String[] args) {
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs=null;
try {
conn= DBUtil.getConnection();
String sql="select * from t_user where loginName like ?";
ps=conn.prepareStatement(sql);
ps.setString(1,"王%");
rs=ps.executeQuery();
while(rs.next()){
System.out.println(rs.getString("loginName"));
System.out.println(rs.getInt("loginPwd"));
System.out.println(rs.getString("realName"));
}
} catch (SQLException e) {
e.printStackTrace();
}finally {
DBUtil.close(conn,ps,rs);
}
}
}
搭上这一生命的列车,感受这生命的起点与终点

浙公网安备 33010602011771号