我写了一个JDBC连接数据库代码,想在控制台输入要查询的数据,怎么用Scanner类来实现?

2025-02-28 19:14:31
推荐回答(5个)
回答1:

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
/**
* jdbc java 操作数据库
* 1,加载驱动 导入jar包
* 2,建立连接
* 3,操作
* 4,释放资源
* @author Administrator
*
*/
public class JdbcDemo {

public static String getSql() {
Scanner sc = new Scanner(System.in);
return sc.nextLine();
}

public static void main(String[] args) {
Connection con=null;
Statement stmt=null;
ResultSet rs=null;
try {
//创建连接
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:study", "bjsxt", "bjsxt");

String sql = getSql()";

stmt=con.createStatement();
rs=stmt.executeQuery(sql);
if(rs.next()){
System.out.println("登录成功!");
}else{
System.out.println("登录失败!");
}
while(rs.next()){
Thread.sleep(500);
System.out.println(rs.getString(1)+","+rs.getDouble(2)+","+rs.getInt(3));
}
} catch (Exception e) {
}finally{
try {
if (rs != null) {
rs.close();
}
} catch (Exception e2) {
}
try {
if (stmt != null) {
stmt.close();
}
} catch (Exception e2) {
}
try {
if (con != null) {
con.close();
}
} catch (Exception e2) {
}
}
}
}

回答2:

if(rs.next()){
System.out.println("登录成功!");
}else{
System.out.println("登录失败!");
}
while(rs.next()){//上面已经.rs.next了,所有这里的循环就改成do while吧
Thread.sleep(500);
System.out.println(rs.getString(1)+","+rs.getDouble(2)+","+rs.getInt(3));
}

回答3:

下面这段代码就是从控制台输入然后再输出的句子,程序运行开始输入,回车则停止,然后将输入内容保存到字符串s中
InputStreamReader isr = new InputStreamReader(System.in);
BufferedReader br = new BufferedReader(isr);
try {
String s = br.readLine();
System.out.println(s);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

回答4:

又是一个马士兵的学生,你可以通过循环实现

回答5:

sdvcsdvsdvsdvs