JDBC—Redis的使用

redis的java-jdbc的下载地址 : http://code.google.com/p/jdbc-redis/

代码例子：插入10万的数据

package com.redis;<br/>import java.sql.Connection;<br/>import java.sql.DriverManager;<br/>import java.sql.ResultSet;<br/>import java.sql.SQLException;<br/>import java.sql.Statement;<br/>/**<br/> * @author zhujiadun.pt<br/> *<br/> */<br/>public class TestRedis {<br/> /**<br/> * @param args<br/> * @throws ClassNotFoundException<br/> * @throws SQLException<br/> */<br/> public static void main(String[] args) throws ClassNotFoundException, SQLException {<br/> //装载Redis数据库的驱动器<br/> Class.forName("br.com.svvs.jdbc.redis.RedisDriver");

//连接数据库
Connection conn = DriverManager.getConnection("jdbc:redis://localhost");

//获取Statement
Statement stmt = conn.createStatement();

//执行SQL语句
for(int i=0;i<100000;i++){
stmt.execute("set my_first_key"+i+" my first value"+i);
}

stmt.execute("get my_first_key");
ResultSet r = stmt.getResultSet();
while (r.next()) {
System.out.println(">" + r.getString(0) + "<");
}
}
}

另一段经典的jdbc代码

package com.Redis.Demo;<br/>import java.sql.Statement;<br/>import java.sql.Connection;<br/>import java.sql.DriverManager;<br/>import java.sql.ResultSet;<br/>import java.sql.SQLException;<br/>public class RedisDemo {<br/>private static Connection conn = null;<br/>private static Statement stm = null;<br/>private static ResultSet rs = null;<br/>/**<br/> * @param args<br/> * @throws SQLException<br/> */<br/>public static void main(String[] args) throws SQLException {<br/>init();<br/>oneKey();<br/>manyKey();<br/>}<br/>/*<br/> * 初始化<br/> */<br/>private static void init() {

try {
// 加载redis jdbc驱动
Class.forName("br.com.svvs.jdbc.redis.RedisDriver");
// 连接
conn = DriverManager.getConnection("jdbc:redis://192.168.1.117");
stm = conn.createStatement();
} catch (ClassNotFoundException e) {
System.out.println(e.toString());
} catch (SQLException e) {
System.out.println(e.toString());
}
}
/*
* 关闭stm,conn
*/
private static void close() {
try {
// rs.close();
stm.close();
conn.close();
} catch (SQLException e) {
System.out.println(e.toString());
}
}
/*
* 一个键值的操作
*
*/
private static void oneKey() throws SQLException {
String sql = "set my_first_key myfirstvalue";
stm.execute(sql);
stm.execute("get my_first_key");
ResultSet rs = stm.getResultSet();
while (rs.next()) {
System.out.println(rs.getString("my_first_key"));
}
close();
}
/*
* 一个key对多个value操作
*/
private static void manyKey() throws SQLException {
stm.execute("lpush mylist value1");
stm.execute("lpush mylist value2");
stm.execute("lpush mylist value3");

stm.execute("lrange mylist 0 -1");

ResultSet rs=stm.getResultSet();

while(rs.next()){
System.out.println(rs.getString("mylist"));
}
}
}