jdbC连接到数据库

来源：互联网发布：捡宝贝淘宝u站编辑：程序博客网时间：2024/06/09 23:08
<span style="font-size:18px;">package cn.aweiyo.jdbc;import java.sql.Driver;import java.sql.DriverManager;import java.sql.DriverPropertyInfo;import java.sql.SQLException;import java.sql.Statement;import java.util.Properties;import org.junit.Test;import com.mysql.jdbc.Connection;import com.mysql.jdbc.ResultSet;public class JDBCtest {@Testpublic void demo1() throws ClassNotFoundException, SQLException {  Class.forName("com.mysql.jdbc.Driver") ; //加载MySQL的驱动类                                           java.sql.Connection con =                 DriverManager.getConnection("jdbc:mysql://localhost:3306/day13" , "root" , "1" )  ;  Statement stmt = con.createStatement() ;     ResultSet rs = (ResultSet) stmt.executeQuery("SELECT * FROM user") ;    while(rs.next()){       String name = rs.getString("name") ;         System.out.println(name);  }              </span><pre name="code" class="java">package cn.aweiyo.jdbc;import java.sql.Driver;import java.sql.DriverManager;import java.sql.DriverPropertyInfo;import java.sql.SQLException;import java.sql.Statement;import java.util.Properties;import org.junit.Test;import com.mysql.jdbc.Connection;import com.mysql.jdbc.ResultSet;public class JDBCtest {@Testpublic void demo1() throws ClassNotFoundException, SQLException {//加载MySQL              Class.forName("com.mysql.jdbc.Driver") ; //建立连接  java.sql.Connection con =                 DriverManager.getConnection("jdbc:mysql://localhost:3306/day13" , "root" , "1" )  ;  Statement stmt = con.createStatement() ;     ResultSet rs = (ResultSet) stmt.executeQuery("SELECT * FROM user") ;    while(rs.next()){       String name = rs.getString("name") ;       String pass = rs.getString(1) ;    System.out.println(name);  }//关闭资源  rs.close() ;   stmt.close();  con.close();}}
rs.close() ; stmt.close(); con.close();}}
0 0