?? database.java~7~
字號:
package bookshop.util;/** * <p>數據專用包 </p> * <p>負責數據庫的連接，數據的插入更新和刪除 </p> * <p>Copyright: wxy Copyright (c) 2004</p> * <p>Company:juanjuan book shop online </p> * @by :wxy * @version 1.0 */import java.sql.*;public class DataBase { public Connection conn; public Statement stmt; public ResultSet rs; public String sqlStr=""; public DataBase() { } public boolean connect(){ try{ Class.forName("org.gjt.mm.mysql.Driver").newInstance(); String url ="jdbc:mysql://localhost/BookStore?user=wxy&useUnicode=true&characterEncoding=8859_1"; conn=DriverManager.getConnection(url); stmt = conn.createStatement (); }catch(Exception ee){ System.out.println("connect db error:"+ee.getMessage()); return false; } return true; } public static void main(String[] args) { try{ DataBase db = new DataBase(); db.connect(); Statement stmt=db.conn.createStatement(); ResultSet rs=stmt.executeQuery("select * from BookAdmin"); while(rs.next()){ System.out.print("名稱: "+rs.getString(1)); System.out.print("\tpassword: "+rs.getString(2)); System.out.println(); } }catch(Exception e){ e.printStackTrace(); } }}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -