import com.MySQL.jdbc.Connection;
//連接數(shù)據(jù)庫時(shí)首先要導(dǎo)入jdbc_mysql.jar驅(qū)動(dòng)程序，可在網(wǎng)上下載，通過eclipse導(dǎo)入擴(kuò)展jars文件導(dǎo)入開發(fā)項(xiàng)目
public class JDBCtest1 {public static void main(String[] args) throws SQLException,ClassNotFoundException {try {//載入jdbc-mysql 驅(qū)動(dòng)
Class.forName("com.mysql.jdbc.Driver");// String url = "jdbc:mysql://localhost:3306/jdbctest";// String user = "root";// String passWord = "123456";//連接數(shù)據(jù)庫Connection conn = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/jdbctest", "root", "123456");//生產(chǎn)Statement對(duì)象Statement stme = ((java.sql.Connection) conn).createStatement();//提交查詢結(jié)果，返回結(jié)果集ResultSet rs = stme.executeQuery("Select * from student" ); //讀取結(jié)果集 if (rs.next()) {System.out.PRint("學(xué)號(hào):"+rs.getString(1)+" ");System.out.print("姓名:"+rs.getString(2)+" ");System.out.print("年齡:"+rs.getString(3));System.out.println();} else {System.out.println("數(shù)據(jù)庫無數(shù)據(jù)");} rs.close(); stme.close(); conn.close();} catch (ClassNotFoundException e) {// TODO Auto-generated catch blockSystem.out.println(e.getMessage());}catch (Exception e) {System.out.println("數(shù)據(jù)庫不存在，鏈接出錯(cuò)");}}}新聞熱點(diǎn)
疑難解答
圖片精選
