package MySqlTest;
import java.sql.*;public class testMysql {
public static void main(String[] args) { Connection conn = null; Statement ste = null; try { //加载驱动 Class.forName("com.mysql.jdbc.Driver");
System.out.println("加载驱动成功");
}catch(ClassNotFoundException e){
System.out.println("加载驱动失败");
e.printStackTrace();
}
//创建Connection对象
try{
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysqltest", "root", "227227");
ste=conn.createStatement();
System.out.println("数据库连接成功");
}catch(ClassNotFoundException e){
System.out.println("数据库连接失败");
e.printStackTrace();
}
//编写Sql语句 String sql = "select name,id from testmysql"; //执行sql语句 ResultSet rs = ste.executeQuery(sql); while(rs.next()){ int id = rs.getInt("id"); String name = rs.getString("name"); System.out.println("id:"+id+"name:"+name); } }《错误在这个括号》错误信息是Exception in thread "main" java.lang.Error: Unresolved compilation problem:
Syntax error, insert "}" to complete ClassBody at MySqlTest.testMysql.main(testMysql.java:52)
import java.sql.*;public class testMysql {
public static void main(String[] args) { Connection conn = null; Statement ste = null; try { //加载驱动 Class.forName("com.mysql.jdbc.Driver");
System.out.println("加载驱动成功");
}catch(ClassNotFoundException e){
System.out.println("加载驱动失败");
e.printStackTrace();
}
//创建Connection对象
try{
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysqltest", "root", "227227");
ste=conn.createStatement();
System.out.println("数据库连接成功");
}catch(ClassNotFoundException e){
System.out.println("数据库连接失败");
e.printStackTrace();
}
//编写Sql语句 String sql = "select name,id from testmysql"; //执行sql语句 ResultSet rs = ste.executeQuery(sql); while(rs.next()){ int id = rs.getInt("id"); String name = rs.getString("name"); System.out.println("id:"+id+"name:"+name); } }《错误在这个括号》错误信息是Exception in thread "main" java.lang.Error: Unresolved compilation problem:
Syntax error, insert "}" to complete ClassBody at MySqlTest.testMysql.main(testMysql.java:52)
解决方案 »
- Spring 的java mail的问题,如何伪装发件人?
- 关于Spring freemarker的问题。急!!!
- 向高手求解!
- 求struts2 的运行原理
- 用java调用webservice出现的错误
- http://topic.csdn.net/u/20080729/10/823420cc-6a90-49b0-aa9c-c00542dba210.html?seed=185707771(相信CSDN上没人能解决)
- query.list()报空指针异常
- From表单怎么提交apk文件?
- 哪有下载struts标签的文档?
- UnmarshalException问题。
- 关于java 3D的一些问题
- 求写一个正则表达式
如果用工具,它会提示你的呀。