准备工作:
1、安装jdk,Eclipse,mysql
2、数据库可以正常访问,jdk环境变量已配置
3、mysql-connector-java-5.0.8-bin.jar包导入java工程
4、本次演示的是访问mysql中一个数据库中的一张表
package com.shanliu.sql;
import java.sql.*;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.ResultSet;
import com.mysql.jdbc.Statement;
public class MySql {
public static void main(String[] args) {
// TODO Auto-generated method stub
//驱动字符串
String driver="com.mysql.jdbc.Driver";
//连接数据库地址
String url="jdbc:mysql://192.168.57.21/t_epa_source";
//访问数据库用户名
String user="root";
//访问数据库密码
String passwd="Zhcs@2014";
try {
//加载驱动
Class.forName(driver);
Connection conn =(Connection) DriverManager.getConnection(url,user,passwd);
if(!conn.isClosed())
{
System.out.println("Success connecting to the Database");
}
//statement用啦执行SQL语句
Statement statement = (Statement) conn.createStatement();
//要执行的SQL语句
String sql = "select sfzh,name,time1 from testsjc where id<10";
//执行SQL后的结果集放在rs对象中
ResultSet rs = (ResultSet) statement.executeQuery(sql);
System.out.println("-----------------");
System.out.println("执行结果如下");
System.out.println("身份证号"+"\t"+"\t"+"姓名"+"\t"+"时间Time1");
System.out.println("------------------");
//String sname=null;
while(rs.next())
{
//选择NAME这一列
String name=rs.getString("name");
String sfzh=rs.getString("sfzh");
//String time1=rs.getDate("time1").toString();
Date time1=rs.getDate("time1");
//输出结果
System.out.println(name+"\t"+sfzh+"\t"+time1);
}
rs.close();
conn.close();
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
}
}