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) {
}
}
}
}
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));
}
下面这段代码就是从控制台输入然后再输出的句子,程序运行开始输入,回车则停止,然后将输入内容保存到字符串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();
}
又是一个马士兵的学生,你可以通过循环实现
sdvcsdvsdvsdvs