id name score tel
1 aaa 60 142
21 bbb 65 541
13 ccc 21 113
2 aaa 11 555
5 eee 68 874
3 bbb 78 999
我想根据 根据ID 和姓名 查询到 SCORE 然后把他们存储到一个数组中String[] sorce=null;
String[] strid=null;//这里可以是多个ID 号
// 载入驱动
Class.forName("com.mysql.jdbc.Driver");
// 建立连接
String url= "jdbc:mysql://localhost:3306/dataid_base?user=jjz&password=jjz&useUnicode=true&characterEncoding=GBK";
Connection con = DriverManager.getConnection(url);
// 创建状态
Statement stmt = con.createStatement();
// 执行SQL语句,返回结果集
for(int i=0;i<array.length;++i)
{
int j=0;
strid[j]=array[i];
ResultSet rs = stmt.executeQuery("select content from usercases where id ='" + strid[j]?+ "' and name=" + name); 系统提示这个有错误??
j++;
// 对结果集进行处理
while (rs.next()) {
sorce[i]= rs.getString("sorce");
System.out.print(sorce[i]);
}
}
我这样写 为什么会出错啊 我是新人 谢谢大家 给我指导!
1 aaa 60 142
21 bbb 65 541
13 ccc 21 113
2 aaa 11 555
5 eee 68 874
3 bbb 78 999
我想根据 根据ID 和姓名 查询到 SCORE 然后把他们存储到一个数组中String[] sorce=null;
String[] strid=null;//这里可以是多个ID 号
// 载入驱动
Class.forName("com.mysql.jdbc.Driver");
// 建立连接
String url= "jdbc:mysql://localhost:3306/dataid_base?user=jjz&password=jjz&useUnicode=true&characterEncoding=GBK";
Connection con = DriverManager.getConnection(url);
// 创建状态
Statement stmt = con.createStatement();
// 执行SQL语句,返回结果集
for(int i=0;i<array.length;++i)
{
int j=0;
strid[j]=array[i];
ResultSet rs = stmt.executeQuery("select content from usercases where id ='" + strid[j]?+ "' and name=" + name); 系统提示这个有错误??
j++;
// 对结果集进行处理
while (rs.next()) {
sorce[i]= rs.getString("sorce");
System.out.print(sorce[i]);
}
}
我这样写 为什么会出错啊 我是新人 谢谢大家 给我指导!
空针
String[] sorce = new String[count]
这个问号是什么意思 多余的吧
例如你建立一个封装四属性的类pepoleInfo.java
size可以根据你获得数据的个数来确定
pepoleInfo[] pepoleInfoArr=new pepoleInfo[size];
// TODO Auto-generated method stub
List list = new ArrayList();
conn = util.DButil.getSqlConnection(); String sql = "select semester,cname,dname, * from Students inner join College on Students.cid = College.cid inner join Department on Students.did = Department.did inner join Special on Students.spid= Special.spid ";
try {
pstm = conn.prepareStatement(sql);
rs = pstm.executeQuery();
while (rs.next()) {
StudentBean sb = new StudentBean(Integer.parseInt(rs
.getString("sid")), rs.getString("sname"), rs
.getString("sex"), rs.getString("birthdaty"), rs
.getString("semester"), Integer.parseInt(rs
.getString("cid")), Integer.parseInt(rs
.getString("did")), Integer.parseInt(rs
.getString("spid")), rs.getString("nation"), rs
.getString("nativeplace"), rs.getString("politics"), rs
.getString("address"), rs.getString("postcode"), rs
.getString("phone"), rs.getString("email"), rs
.getString("re"));
sb.setSpname(rs.getString("spname"));
sb.setCname(rs.getString("cname"));
sb.setDname(rs.getString("dname"));
list.add(sb); }
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}