import java.io.UnsupportedEncodingException;public class Change {
public static String trans(String string) {
String result = null; try {
byte temp[] = string.getBytes("ISO8859-1");
result = new String(temp);
} catch (UnsupportedEncodingException e) {
System.out.println(e.toString());
}
return result;
}
}
import java.sql.*;public class Mysql {
String driver = "org.gjt.mm.mysql.Driver"; String str = "jdbc:mysql://localhost:3306/test?user=root&password=&useUnicode=true&characterEncoding=8859_1"; Statement stmt =null;
ResultSet rs = null;
Connection conn =null;
public Mysql() {
try {
Class.forName(driver);
conn = DriverManager.getConnection(str);
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
} catch (Exception e) {
e.printStackTrace();
}
} public void doInsert() {
// Change change = new Change();
//String sql = "insert test(name) values('"+Change.trans("张三")+"')";
String sql = "insert test(name) values('张三')";
try{
stmt.executeUpdate(sql);
System.out.println("hello");
}catch(Exception e){
e.printStackTrace();
}
}
public ResultSet getRs(){
String sql = "select * from test";
try{
rs = stmt.executeQuery(sql);
}catch(Exception e){
e.printStackTrace();
}
return rs;
} public static void main(String[] args) {
Mysql mysql = new Mysql();
mysql.doInsert();
}
}
为什么插入的数据还是问号呢?????
public static String trans(String string) {
String result = null; try {
byte temp[] = string.getBytes("ISO8859-1");
result = new String(temp);
} catch (UnsupportedEncodingException e) {
System.out.println(e.toString());
}
return result;
}
}
import java.sql.*;public class Mysql {
String driver = "org.gjt.mm.mysql.Driver"; String str = "jdbc:mysql://localhost:3306/test?user=root&password=&useUnicode=true&characterEncoding=8859_1"; Statement stmt =null;
ResultSet rs = null;
Connection conn =null;
public Mysql() {
try {
Class.forName(driver);
conn = DriverManager.getConnection(str);
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
} catch (Exception e) {
e.printStackTrace();
}
} public void doInsert() {
// Change change = new Change();
//String sql = "insert test(name) values('"+Change.trans("张三")+"')";
String sql = "insert test(name) values('张三')";
try{
stmt.executeUpdate(sql);
System.out.println("hello");
}catch(Exception e){
e.printStackTrace();
}
}
public ResultSet getRs(){
String sql = "select * from test";
try{
rs = stmt.executeQuery(sql);
}catch(Exception e){
e.printStackTrace();
}
return rs;
} public static void main(String[] args) {
Mysql mysql = new Mysql();
mysql.doInsert();
}
}
为什么插入的数据还是问号呢?????
解决方案 »
- 这样配置的struts应用是什么原理?
- 大家帮忙看看这段代码什么意思?
- Only a type can be imported
- 急!jsp连接sqlsever时的问题
- 关于Tomcat服务器被大量访问的优化~~~
- JSF中页面加载时就执行action的问题。(谢谢了,急)
- 这么放iframe为什么显示不出来?
- session在第二次提交失效??
- 在JAVA中怎么判断输入的是字符标点符号和数字啊?
- ●●●怎么传中文地址!!!急……急……急……急……急的不得了,了不得了●●●●●●●●●●●●●●
- 数据库连接问题!
- 如何把int,string等多个类型放到一个byte[]数组里面啊,我想用socket发出去
把=&useUnicode=true&characterEncoding=8859_1去掉