1.jdbc连接代码
<span style="font-size:14px;">package com.tl.demo;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class TestJdbcDemo {
public static void main(String[] args) throws SQLException {
// MySQL的JDBC URL编写方式:jdbc:mysql://主机名称:连接端口/数据库的名称?参数=值
// 避免中文乱码要指定useUnicode和characterEncoding
String url = "jdbc:mysql://localhost:3306/mydemo?"
+ "user=root&password=123&useUnicode=true&characterEncoding=UTF8";
String sql;
Connection conn = null;
try {
// 加载MySql的驱动类
Class.forName("com.mysql.jdbc.Driver");
// 连接数据库
conn = DriverManager.getConnection(url);
// 创建statement语句,
// Statement接口提供了三种执行SQL语句的方法:executeQuery、executeUpdate和execute
Statement stmt = conn.createStatement();
// sql = "create table student(id char(20),name varchar(20),primary key(id))";
// executeUpdate语句会返回一个受影响的行数,如果返回-1就没有成功
// int rows = stmt.executeUpdate(sql);
// System.out.println(rows);
// if (rows != -1) {
if(true){
int rows;
System.out.println("数据库新建成功");
// 插入数据1
sql = "insert into student(id,name) values('20150417','韦小宝')";
rows = stmt.executeUpdate(sql);
// 插入数据2
sql = "insert into student(id,name) values('20150416','张无忌')";
rows = stmt.executeUpdate(sql);
// 查询数据,返回结果集ResultSet
sql = "select * from student";
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
System.out
.println("id:"+rs.getString(1) + "\t" + "name:"+rs.getString(2));
}
}
} catch (ClassNotFoundException e) {
System.out.println("类未找到异常");
e.printStackTrace();
} catch (SQLException e) {
// try {
// throw new Exception("异常");
// } catch (Exception e1) {
// e1.printStackTrace();
// }
e.printStackTrace();
} finally {
conn.close();
}
}
}
</span>
2.ResultSet
用法很简单的
//遍历每一条数据记录
ResultSet rs = stmt.executeQuery(sql);</span>
while(rs.next()){
rs.getString(0);//取第一列数据
rs.getString(1);//取第二列数据
rs.getString("id");//取列名为"id"列的数据
}