程式要連線分成3個動作
1.告訴程式我們要連什麼資料庫,所以我們需要不同的工具,像我們要連oracle資料庫,我們就要用oracle提供的工具,如 ojdbc14.jar
2.告訴程式資料庫的位置(網址)、帳號、密碼
3.下資料庫命令,如select之類的
環境:
1.Eclipse Java EE IDE for Web Developers (4.4.1)
2.JDK 1.8
3.CLASSES12.JAR
首先匯入CLASSES12.JAR : Project --> Properties --> JAVA Buile Path -->Libraries --> Add External JARs (匯入Classes12.jar)
String driver = "oracle.jdbc.driver.OracleDriver";
PreparedStatement stmt;
ResultSet rs;
String default_user="testuser";
String default_pwd="testpwd";
String default_url="jdbc:oracle:thin:@lulu.com.tw:1521:test";
public myServlet() {
super();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("UTF8");
response.setCharacterEncoding("UTF8");
System.out.println(request.getParameter("datafromtestFile"));
String happyString="Hello";
try {
Class.forName(driver).newInstance();
Connection conn=null;
conn = DriverManager.getConnection(default_url,default_user, default_pwd);
String select_command="SELECT * FROM APPLYAIC";
stmt=conn.prepareStatement(select_command);
rs = stmt.executeQuery();
while(rs.next()){
System.out.println(rs.getString("DATES"));
}
} catch (Exception e) {
// TODO: handle exception
System.out.println("in the catch");
e.printStackTrace();
}
//告訴程式,這是要連什麼資料庫
Class.forName(driver).newInstance();
//給帳號密碼,開始連線
Connection conn=null;
conn = DriverManager.getConnection(default_url,default_user, default_pwd);
//設定資料庫指令
String select_command="SELECT * FROM APPLYAIC";
stmt=conn.prepareStatement(select_command);
//對資料庫下指令,資料庫會把結果回傳回來,我們把它存進resultset rs裡面
rs = stmt.executeQuery();
//把rs裡面所有資料印出來,用getString代表這個欄位在資料庫是STRING 用getInt代表這個欄位在資料庫是int
while(rs.next()){
System.out.println(rs.getString("DATES"));
留言列表