调用类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);
}
}

}
posted @ 2020-03-16 12:08  星月星辰  阅读(319)  评论(0)    收藏  举报