TA貢獻(xiàn)1條經(jīng)驗(yàn) 獲得超3個(gè)贊
try?{
????????????//這里的是MYSQL?舉例
????????????//加載驅(qū)動(dòng)?
????????????Class.forName("com.mysql.jdbc.Driver");
????????????//創(chuàng)建數(shù)據(jù)庫連接
????????????Connection?con?=?DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");
????????????//創(chuàng)建查詢?“請求”
????????????PreparedStatement?ps?=?con.prepareStatement("select?*?from?user");
????????????//返回查詢結(jié)果
????????????ResultSet?rs?=?ps.executeQuery();
????????????//遍歷結(jié)果
????????????while(rs.next())?{
????????????????//假如?User?表中?有個(gè)?name?列
????????????????System.out.println("name?>>?"+rs.getString("name"));
????????????}
????????????//關(guān)閉
????????????rs.close();
????????????ps.close();
????????????con.close();
????????}?catch?(Exception?e)?{
????????????e.printStackTrace();
????????}
TA貢獻(xiàn)3593條經(jīng)驗(yàn) 獲得超0個(gè)贊
TA貢獻(xiàn)3593條經(jīng)驗(yàn) 獲得超0個(gè)贊
舉報(bào)