956
社区成员
发帖
与我相关
我的任务
分享
*1*,蕭????C Ap16012#1(1-1)??C Ap16012#1(1-1) 10GbE?祉??激???
*2*,蕭????C Ap16012#1(1-1)??C Ap16012#1(1-1) 10GbE?祉??激???
*3*,??申鐃緒申鐃? Ap16012#1(1-1)鐃緒申C Ap16012#1(1-1) 10GbE鐃順?鐃緒申羶?申鐃緒申
*4*,蕭????C Ap16012#1(1-1)??C Ap16012#1(1-1) 10GbE?祉??激???
*5*,蕭????C Ap16012#1(1-1)??C Ap16012#1(1-1) 10GbE?祉??激???
*6*,?????C Ap16012#1(1-1)??C Ap16012#1(1-1) 10GbE??????????
*7*,?????C Ap16012#1(1-1)??C Ap16012#1(1-1) 10GbE??????????
另小程序代码如下:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class JDBCTest {
public static void main(String[] args) {
String driver = "org.postgresql.Driver";
String dbName = "数据库名";
String passwrod = "密码";
String userName = "用户名";
String url = "jdbc:postgresql://postgresqlIP地址:5432/" + dbName;
String sql = "select col from dbname"
try {
Class.forName(driver);
Connection conn = DriverManager.getConnection(url, userName,
passwrod);
PreparedStatement ps = conn.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
String r1 = "";
String r2 = "";
String r3 = "";
String r4 = "";
String r5 = "";
String r6 = "";
while (rs.next()) {
//2
r1=new String(rs.getString(1).getBytes(), "EUC-JP");
//3
r2=new String(rs.getString(1).getBytes("UTF-8"), "EUC-JP");
//4
r3=new String(rs.getString(1).getBytes("EUC-JP"), "EUC-JP");
//5
r4=new String(rs.getString(1).getBytes("UTF-8"), "UTF-8");
//6
r5=new String(rs.getString(1).getBytes("EUC-JP"), "UTF-8");
//7
r6=new String(rs.getString(1).getBytes(), "UTF-8");
System.out.println( "*1*"+ rs.getString(1) + "*2*" + r1 + "*3*" + r2
+ "*4*" + r3 + "*5*" + r4 + "*6*" + r5 + "*7*" + r6);
}
// 关闭记录集
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
// 关闭声明
if (ps != null) {
try {
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
// 关闭链接对象
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
while (resultSet.next()) {
String vlanName = new String(resultSet.getString("service_name").getBytes("UTF-8"),"EUC-JP");
但是界面显示还是乱码,现在还没搞定呢