我的数据库创建脚本:(mysql数据库)
CREATE TABLE person
(
id varchar(20) not null primary key ,
name varchar(20) ,
password varchar(20)
) ;
INSERT INTO person VALUES ('LXH','李兴华','zzzzzz') ;
连接数据库程序:<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%!
String DBDRIVER = "com.mysql.jdbc.Driver" ;
String DBURL = "jdbc:mysql://localhost:3306/mldn" ;
String DBUSER = "root" ;
String DBPASSWORD = "123456" ;
Connection conn = null ;
Statement pstmt = null ;
ResultSet rs = null ;
%>
<% String sql="SELECT * FROM person ";
try
{
Class.forName(DBDRIVER);
conn=DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);
pstmt=conn.createStatement();
rs=pstmt.executeQuery(sql);
if(rs.next())
{
System.out.println(rs.getString("id"));
System.out.println(rs.getString("name"));
System.out.println(rs.getString("password"));
}
rs.close();
pstmt.close();
conn.close();
}
catch(Exception e)
{
}
%>
输出结果为:LXH ?????? zzzzzz
怎么没得到name的值啊 具体原因是什么???
CREATE TABLE person
(
id varchar(20) not null primary key ,
name varchar(20) ,
password varchar(20)
) ;
INSERT INTO person VALUES ('LXH','李兴华','zzzzzz') ;
连接数据库程序:<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%!
String DBDRIVER = "com.mysql.jdbc.Driver" ;
String DBURL = "jdbc:mysql://localhost:3306/mldn" ;
String DBUSER = "root" ;
String DBPASSWORD = "123456" ;
Connection conn = null ;
Statement pstmt = null ;
ResultSet rs = null ;
%>
<% String sql="SELECT * FROM person ";
try
{
Class.forName(DBDRIVER);
conn=DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);
pstmt=conn.createStatement();
rs=pstmt.executeQuery(sql);
if(rs.next())
{
System.out.println(rs.getString("id"));
System.out.println(rs.getString("name"));
System.out.println(rs.getString("password"));
}
rs.close();
pstmt.close();
conn.close();
}
catch(Exception e)
{
}
%>
输出结果为:LXH ?????? zzzzzz
怎么没得到name的值啊 具体原因是什么???
jdbc:mysql://localhost/databasename?useUnicode=true&characterEncoding=GB2312
我添加了这句 好象还是不行啊 怎么回事?