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)
解决方案 »
- ajax轮询,如何使session失效
- org.hibernate.PropertyNotFoundException: Could not find a setter for property id in class
- Date类型插入数据库后,丢失时分秒
- STRUTS的问题,帮帮我 在线等
- 数据移植程序框架
- mybatis注解应用
- 请问 J2EE 方面的 经典书藉 有哪些?最好是英文版的
- jboss 启动时报错???
- 更新后的XML中多了空行,如何去除?在线等待,解决即给分!
- 请高手为我的BMP实体EJB诊断 在线等待................
- 关于java 3D的一些问题
- 求写一个正则表达式
如果用工具,它会提示你的呀。