小弟近日在做音乐网站,在站内搜索部分编了个applet ,可是总是报错,我快崩溃了,各位高手给改改看。
import java.awt.*;
import java.applet.*;public class Find extends Applet {
public void init() {
Choice twoChoice = new Choice();//设置选项
twoChoice.addItem("歌曲名");
twoChoice.addItem("歌手名");
String name = twoChoice.getSelectedItem();//返回选项值
TextField t1;//information field
t1 = new TextField("请输入关键字",20);
String word = t1.getSelectedText();//返回关键字
Label findLabel = new Label("查找:");//两个标签
Label informationLabel = new Label("关键字");
Button findButton = new Button("开始查找");//开始按钮
setLayout(new FlowLayout(FlowLayout.LEFT,3,1));//布局管理器
add(findLabel);//添加组件
add(twoChoice);
add(informationLabel);
add(t1);
add(findButton);
}
//public boolean action(Event e,Object o){//按钮事件
// if(e.target instanceof Button){
//if(e.target == findButton)
//}
public void Performed(ActionEvent event){
if(event.getSource() == findButton){
processionRequest();
}
}
private synchronized void processRequest(){
String stringResult = "";
String sesult;
try{//连接数据库
Class.forName("jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:s_singer";
Connection con = DriverManager.getConnection(url,"Sa","password");
//连接
Statement stmt = con.createStatement();//生成Statement对象
String sqlselect="Select s_singer.singer,s_singer.song from s_singer where
s_singer.singer="word" or s_singer.song="word"";
ResultSet rs = stmt.executeQuery(sqlselect);//执行查询语句
while(rs.next()){
int i=0;
result = "";
result = rs.getString(i) + "\n";
stringResult += result;
}
textResult.setText(stringResult);
rs.close();//关闭连接
stmt.close();
}
catch(Exception e){//扑捉例外,并打印
textResult.setText(e.getMessage());
}
}
}
import java.awt.*;
import java.applet.*;public class Find extends Applet {
public void init() {
Choice twoChoice = new Choice();//设置选项
twoChoice.addItem("歌曲名");
twoChoice.addItem("歌手名");
String name = twoChoice.getSelectedItem();//返回选项值
TextField t1;//information field
t1 = new TextField("请输入关键字",20);
String word = t1.getSelectedText();//返回关键字
Label findLabel = new Label("查找:");//两个标签
Label informationLabel = new Label("关键字");
Button findButton = new Button("开始查找");//开始按钮
setLayout(new FlowLayout(FlowLayout.LEFT,3,1));//布局管理器
add(findLabel);//添加组件
add(twoChoice);
add(informationLabel);
add(t1);
add(findButton);
}
//public boolean action(Event e,Object o){//按钮事件
// if(e.target instanceof Button){
//if(e.target == findButton)
//}
public void Performed(ActionEvent event){
if(event.getSource() == findButton){
processionRequest();
}
}
private synchronized void processRequest(){
String stringResult = "";
String sesult;
try{//连接数据库
Class.forName("jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:s_singer";
Connection con = DriverManager.getConnection(url,"Sa","password");
//连接
Statement stmt = con.createStatement();//生成Statement对象
String sqlselect="Select s_singer.singer,s_singer.song from s_singer where
s_singer.singer="word" or s_singer.song="word"";
ResultSet rs = stmt.executeQuery(sqlselect);//执行查询语句
while(rs.next()){
int i=0;
result = "";
result = rs.getString(i) + "\n";
stringResult += result;
}
textResult.setText(stringResult);
rs.close();//关闭连接
stmt.close();
}
catch(Exception e){//扑捉例外,并打印
textResult.setText(e.getMessage());
}
}
}
解决方案 »
- 求解开发图算法时 怎没用java来生成一个随即图 java中有图的ATD但是如何实现的~~~
- 关于一个递归的问题……
- 我的oracle cursor 指针不下移
- 怎样才能让SWT的browser打开网页时不弹出脚本错误窗口
- 如何分析java core 有什么好的工具或者方法
- 各位朋友问个问题,java很多调用的函数的用法怎么看啊?
- 在Java中如何使用字符串连接sql server7.0
- 【关于resultset】我想找到resultset中的记录个数,在使用last函数的时候,总是报错:对只转发结果集的无效操作: last
- 如何识别输入的是中文还是英文的问题?
- 大家来讨论一下,作为一个“程序人”,他的人生价值到底在哪里??!!
- 再开ServerSocketChannel
- 帮忙 散分了
E:\Program Files\Xinox Software\JCreatorV3\MyProjects\Find\src\Find.java:43: unclosed string literal
String sqlselect="Select s_singer.singer,s_singer.song "+"from s_singer where
^
E:\Program Files\Xinox Software\JCreatorV3\MyProjects\Find\src\Find.java:44: unclosed string literal
s_singer.singer="word" or s_singer.song="word"";
^
2 errors
这是我们期末的一个作业,并不上传到网上,多谢 naxin(痴呆男人--我痴呆,我自豪!!) 关心!
大家给帮忙看一下好吗?
应该是s_singer.singer='word'or s_singer.song='word'";用单引号吧...
s_singer.singer="word" or s_singer.song="word"";应该改为:
String sqlselect="Select s_singer.singer,s_singer.song from s_singer where
s_singer.singer=\'"+ word +"\'" + " or s_singer.song=\'"+word+ "\'";