谁有JAVA按条件查询数据库内容并显示出来的源代码 能给我看下吗？？？谢谢啦 本人新手~

发布网友 发布时间：2022-04-09 04:36

我来回答

共3个回答

懂视网 时间：2022-04-09 08:57

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(); } } }

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

1.用jdbc连接数据库
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

网上找示例