JAVA用JDBC模式简单的连接数据库

来源：互联网发布：淘宝搜索技术黑搜索编辑：程序博客网时间：2024/06/15 14:39

一个简单的例子，用的MySql数据库，用其它数据库就是驱动和URL那些配置变一下，另外，导入的JAR包也要换一下。

package test.hello;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;public class HelloJDBC {/** * @param args */public static void main(String[] args) {String driver = "com.mysql.jdbc.Driver";//驱动String url = "jdbc:mysql://localhost:3306/test";//数据库URLString userName = "root";//数据库用户名String pas = "root";//密码// 加载驱动try {Class.forName(driver);} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();}// 得到连接Connection conn;try {conn = DriverManager.getConnection(url, userName, pas);//得到连接String sql = "select * from student";//编写查询的SQL语句PreparedStatement pstmt = conn.prepareStatement(sql);//创建PreparedStatementResultSet rs = pstmt.executeQuery();//执行查询得到结果集while (rs.next()) {//遍历结果集String uid = rs.getString("uid");String uname = rs.getString("uname");String uage = rs.getString("uage");System.out.println("-------------------------");System.out.println("ID：" + uid);System.out.println("Name:" + uname);System.out.println("uage:" + uage);System.out.println("-------------------------");}} catch (SQLException e1) {// TODO Auto-generated catch blocke1.printStackTrace();}}}