解决Java和Sql Server的汉字问题
来源:互联网 发布:上海九院口腔科 知乎 编辑:程序博客网 时间:2024/05/01 03:18
<script type="text/javascript">google_ad_client = "pub-8800625213955058";/* 336x280, 创建于 07-11-21 */google_ad_slot = "0989131976";google_ad_width = 336;google_ad_height = 280;//</script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>用Jdbc-Odbc和Sql Server7.0打交道,查询和插入会出现掉汉字的情况。要解决,很简单,去www.freetds.org下载freetds最新驱程0.5版。再也不用把编码转来转去那么麻烦。源程序如下:String url = "jdbc:freetds:sqlserver://ServerName:port/DataBase"; String login = "UserName"; String password = "PassWord";try{ Class.forName("com.internetcds.jdbc.tds.Driver").newInstance(); Connection connection = DriverManager.getConnection(url,login,password); Statement st = connection.createStatement(); ResultSet rs = st.executeQuery("select * from JoltData"); while (rs.next()) { for(int j=1; j<=rs.getMetaData().getColumnCount(); j ) { System.out.print( rs.getObject(j) "/t"); } System.out.println(); } st.close(); connection.close();} catch(Exception e){ System.out.println(e.toString());}