谁有JAVA按条件查询数据库内容并显示出来的源代码 能给我看下吗？？？谢谢啦 本人新手~
发布网友
发布时间：2022-04-09 04:36
共3个回答
懂视网
时间：2022-04-09 08:57
package lianxi2;
import java.sql.*;
import java.util.Scanner;
public class lianxi2 {
public static void main(String[] args) {
Connection conn = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
String strUrl ="jdbc:Oracle:thin:@localhost:1521:ORCL";
conn = DriverManager.getConnection(strUrl, "test1", "duibuqi19950220");
System.out.println("链接数据库成功！");
Statement st = conn.createStatement();
System.out.println("请输入身份证号或者学生考号");
System.out.println("a:身份证号");
System.out.println("b:准考证号");
Scanner b = new Scanner (System.in);
String str=b.next();
if(str.equals("a"))
{
System.out.println("请输入身份证号");
String bb = b.next();
ResultSet rs = st.executeQuery("select * from EXAMSTUDENT where IDCard = ‘"+bb+"‘");
while(rs.next())
{
int FlowID = rs.getInt(1);
int Type = rs.getInt(2);
String IDCard = rs.getString(3);
String ExamCard = rs.getString(4);
String StudentName = rs.getString(5);
String Location = rs.getString(6);
int Grade = rs.getInt(7);
System.out.println("序列号是"+FlowID+"四六级"+Type+"身份证号是"+IDCard+"学生考号是"+ExamCard+
"姓名是"+StudentName+"在这所城市"+Location+"成绩是"+Grade);
}
}
else if(str.equals("b"))
{
System.out.println("输入准考证号：");
String aa = b.next();
ResultSet ru = st.executeQuery("select * from EXAMSTUDENT where ExamCard = ‘"+aa+"‘");
while(ru.next())
{
int FlowID = ru.getInt(1);
int Type = ru.getInt(2);
String IDCard = ru.getString(3);
String ExamCard = ru.getString(4);
String StudentName = ru.getString(5);
String Location = ru.getString(6);
int Grade = ru.getInt(7);
System.out.println("序列号是"+FlowID+"四六级"+Type+"身份证号是"+IDCard+"学生考号是"+ExamCard+
"姓名是"+StudentName+"在这所城市"+Location+"成绩是"+Grade);
}
}
else
{
System.out.println("输入有误！");
}
}
catch (Exception e)
{
e.printStackTrace();
}
}
}
java编写在数据库中按条件查询数据
标签：
热心网友
时间：2022-04-09 06:05
public class DBConn {
private Connection con;
public Connection DBConn() {
//连接数据库的属性
String driver="sun.jdbc.odbc.JdbcOdbcDriver";
//获得数据库的真实路径
String dburl = String.valueOf(Thread.currentThread().getContextClassLoader().getResource(""));
dburl = dburl + "lyb.mdb";//得到文件的URL: 'file:/C:\...'
dburl = dburl.substring(dburl.indexOf("/")+1);//去掉'file:/'
//dburl.replaceAll("%20"," ");
System.out.println("dburl :"+dburl);//测试用，运行的时候显示绝对路径
dburl="E:/lyb/WebRoot/WEB-INF/classes/lyb.mdb";
String accessUrl="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="+dburl;
try{
Class.forName(driver);
con = DriverManager.getConnection(accessUrl);
}catch(Exception e){
e.printStackTrace();
}
return con;
}
}
2.比如查询数据库中的record表，record表中存放的是实体MessageVO.
public Collection getMessage() throws Exception{
//SQL语句，从record里面获得所有数据
String getLy="select count(*) from record";
String getLy1="select * from record order by id desc";
Collection ret=new ArrayList();
try{
if(con==null) System.out.println("con=null");
Statement stm=con.createStatement();
ResultSet res=stm.executeQuery(getLy);
int msg_count=0;
if(res.next()){
msg_count=res.getInt(1);
res.close();
}
if(msg_count>0){
res=stm.executeQuery(getLy1);
while(res.next()){
int id=res.getInt("id");
String title=res.getString("title");
String name=res.getString("name");
String email=res.getString("email");
String content=res.getString("content");
java.sql.Timestamp ts=res.getTimestamp("ly_date");
java.sql.Date date=new java.sql.Date(ts.getTime());
//System.out.println(date);
MessageVO message=new MessageVO();
message.setId(id);
message.setTitle(title);
message.setName(name);
message.setEmail(email);
message.setContent(content);
message.setDate(date);
ret.add(message);
}
res.close();
stm.close();
}
con.close();
}catch(Exception e){
e.printStackTrace();
throw e;
}
return ret;
}
热心网友
时间：2022-04-09 07:23
