SecretD
   
發文: 15
積分: 0
|
於 2018-08-21 07:39
     
package mysqltest;
import java.sql.*;
public class mysqltest {
public static void main(String[] args) { DBConnect connection=new DBConnect(); connection.getData(); } } class DBConnect{ private Connection con; private Statement st; private ResultSet rs; public DBConnect() { try { //Class 的靜態 forName() 方法實現動態加載類別 Class.forName("com.mysql.jdbc.Driver"); //3306|MySQL開放此端口 con= DriverManager.getConnection("jdbc:mysql://localhost:3306","root","sssddd248"); st= con.createStatement(); }catch(Exception ex){ System.out.println("Error: "+ex); } } public void getData() { try { String query = "select * from daniel.new_table"; String insert = "Insert Into user Values ('2010301610308','老大','男',58,'123456789','123456789','1234@163.com')"; rs = st.executeQuery(query); System.out.println("Records for Database"); while(rs.next()) { int id = rs.getInt("id"); String name = rs.getString("name"); String password = rs.getString("password"); System.out.println("id= "+id+" name= "+name+" password= "+password); } }catch(Exception ex) { System.out.println(ex); } }
} 這是目前成功的資料庫查詢,但我上網查了一下許多的寫入方式,都只是從程式碼里加入資料,有沒有辦法用scanner透過鍵盤下去查詢嗎
 
|