1.我用select * from web_content在sql plus打印出来的很正常,但运行下面,就出来乱码了,是何故?
2.jdbc:oracle:thin:@127.0.0.1:1521:ORCL?useUnicode=true&characterEncoding=utf-8
此法也不行。
所有代码如下:
package com.hsp.controller;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;public class index {
Connection ct=null;
Statement sm=null;
ResultSet rs=null;
public ResultSet excuteQuery(String sql){
try {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
String url = "jdbc:oracle:thin:@127.0.0.1:1521:ORCL";
String user = "scott";
String psw = "tiger";
//得到连接
Connection ct = DriverManager.getConnection(url,user,psw);
//创建Statement
Statement sm;
sm = ct.createStatement();
rs = sm.executeQuery(sql);
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
//删除与插入不能使用executeQuery
return rs;
}//excuteQuery
public static void main(String[] args){
index index=new index();
ResultSet rr=index.excuteQuery("select * from web_content");
try {
if(rr.next()){System.out.print(rr.getString(4));}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}//main}//index
2.jdbc:oracle:thin:@127.0.0.1:1521:ORCL?useUnicode=true&characterEncoding=utf-8
此法也不行。
所有代码如下:
package com.hsp.controller;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;public class index {
Connection ct=null;
Statement sm=null;
ResultSet rs=null;
public ResultSet excuteQuery(String sql){
try {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
String url = "jdbc:oracle:thin:@127.0.0.1:1521:ORCL";
String user = "scott";
String psw = "tiger";
//得到连接
Connection ct = DriverManager.getConnection(url,user,psw);
//创建Statement
Statement sm;
sm = ct.createStatement();
rs = sm.executeQuery(sql);
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
//删除与插入不能使用executeQuery
return rs;
}//excuteQuery
public static void main(String[] args){
index index=new index();
ResultSet rr=index.excuteQuery("select * from web_content");
try {
if(rr.next()){System.out.print(rr.getString(4));}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}//main}//index
解决方案 »
- 简单的Java问题求解,急!!!!!!!!!
- 关于Struts2 doubleSelect的问题
- hibernate中的小问题
- 想要开始学习做一个通用spider程序,想找一个先看看,希望好心人给个源码
- JBuilder 怎么老是自动关闭
- 如何定时上成一个mdb文件?
- 请问高手用过j2eesdk1.4吗,这个工具是作什么用的,方便的话,请指点一下吧,谢了先
- 求一个jboss3.2下的例子。
- JB7+Weblogic7.0搭建web service少个文件?
- 高分请教jbuilder开发entity bean的完整示例。
- 关于一个Filter无效的问题
- 一个按钮触发鼠标事件 怎么弹出null窗?
System.out.print(rr.getString(4)).getBytes("utf-8");}