jdbc mysql 查询乱码_JDBC向MYSQL插入数据后，查询中文数据为乱码

插入部分代码if(s.equals("出售")){try{Class.forName("org.gjt.mm.mysql.Driver");Connectioncon=DriverManager.getConnection("jdbc:mysql://localhost:3306/myjava","root","sa");...

插入部分代码

if(s.equals("出售")){

try{

Class.forName("org.gjt.mm.mysql.Driver");

Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/myjava", "root", "sa");

Statement stmt=con.createStatement();

stmt.executeUpdate("insert into sale values('"+store+"','"+pro+"',"+price+","+quantity+","+total+");");

con.close();

}

catch(Exception e){

System.out.println("connect fail");

}

}

//查询部分代码

else if(s.equals("当天销售记录")){

try{

Class.forName("org.gjt.mm.mysql.Driver");

Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/myjava", "root", "sa");

Statement stmt=con.createStatement();

ResultSet rs=stmt.executeQuery("select * from sale;");

while(rs.next()){

System.out.print("连锁店:"+rs.getString(1)+" ");

System.out.print("商品:"+rs.getString(2)+" ");

System.out.print("单价:"+rs.getInt(3)+" ");

System.out.print("数量:"+rs.getInt(4)+" ");

System.out.println("总价:"+rs.getInt(5)+" ");

}

con.close();

}

catch(Exception e){

System.out.print("查询失败");

}

}

展开