java 数据库取出 乱码_java获取sql数据库中数据时输出乱码(高分）

昨天刚把java连上sql数据库，今天在eclipse上做了一个算法，需要调用sql数据库中的数据，出现如下错误，好像是乱码：Symptom=Symptom_table@3e0ebbSymptom=Symptom_table@39443fSympt...

昨天刚把java连上sql数据库，今天在eclipse上做了一个算法，需要调用sql数据库中的数据，出现如下错误，好像是乱码：

Symptom=Symptom_table@3e0ebb

Symptom=Symptom_table@39443f

Symptom=Symptom_table@1afae45

Symptom=Symptom_table@da4b71

Symptom=Symptom_table@18f1d7e

Symptom=Symptom_table@d9660d

Symptom=Symptom_table@bb0d0d

Symptom=Symptom_table@55e55f

Symptom=Symptom_table@145c859

Symptom=Symptom_table@64883c

Symptom=Symptom_table@2c1e6b

Symptom=Symptom_table@811c88

Symptom=Symptom_table@785d65

Symptom=Symptom_table@3bc257

Symptom=Symptom_table@153f67e

Symptom=Symptom_table@15bdc50

Symptom=Symptom_table@1dd3812

Symptom=Symptom_table@8c436b

Symptom=Symptom_table@9e5c73

Symptom=Symptom_table@c791b9

Symptom=Symptom_table@3020ad

Symptom=Symptom_table@7f4ec

Symptom=Symptom_table@60e128

Symptom=Symptom_table@5e1077

Symptom=Symptom_table@18b3364

Symptom=Symptom_table@1db05b2

Symptom=Symptom_table@530cf2

Symptom=Symptom_table@76fba0

Symptom=Symptom_table@181ed9e

结果不对，原程序如下，各位朋友帮帮忙！

(1)import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

public class benchmark {

public static void main(String args[]){

Symptom_table[] Symptom= new Symptom_table[29];

int i=0;

String dbUrl = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=海参疾病";

String user = "sa";

String password = "051125";

try {

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

Connection c = DriverManager.getConnection(dbUrl, user,password);

Statement s = c.createStatement();

ResultSet r = s.executeQuery("select SymptomNum,Symptom from Symptom_table");

while (r.next()) {

Symptom[i]=new Symptom_table(r.getInt(1),r.getString(2));//

i++;

}

s.close();

} catch (Exception e) {

e.printStackTrace();

}

for(i=0;i

System.out.println("Symptom="+Symptom[i]);

}

}

(2)

public class Symptom_table{

public int SymptomNum;

public String Symptom;

public Symptom_table(int a,String c){

//this.SymptomNum=a;

//this.Symptom=c;

}

//public void set(int a, String c) {

//this.SymptomNum = a;

//this.Symptom = c;

//}

}

展开