关于jdbc方面的--------------急 大哥帮我

Question

谁能告诉我错在哪吗？
D:\j2sdk1.4.0_03\bin>javac feedbackjdbc.java
feedbackjdbc.java:15: illegal start of expression
                                   public void insert()
                                   ^
feedbackjdbc.java:43: ';' expected
                                 }
                                  ^
2 errors

Answer 1

package jsjdb;
import java.sql.*;
   public class feedbackjdbc   {
   public String idea;
   public String subject;
   public String liuyan;
   public String name;
   public String email;
   public String tel;
   public String fox;
   public static void main(String args[])
  {    
    String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=feedback";   try 
{ 
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
// 加载驱动程序
}
  catch (ClassNotFoundException e) 
{
System.out.println(e.getMessage());
} 
  try
{
 Connection con= DriverManager.getConnection(url, "sa", "sasa");
  Statement stmt=con.createStatement();
                          stmt.executeUpdate("insert into feed values("+ 
 "'idea','subject ','liuyan','name','email','tel','fox')");

 stmt.close();  
 con.close();
}
  catch (SQLException e) 
{
System.out.println(e.getMessage());
 }
  
 }
  }

Answer 2

哥们主方法main中怎么能还包含insert方法啊，系统当然编译不过去了，我把你的程序改了一下就ok了。public class feedbackjdbc
{
    public String idea;
    public String subject;
    public String liuyan;
    public String name;
    public String email;
    public String tel;
    public String fox;    public void insert()
    {
        String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=feedback";
        try
        {
            // 加载驱动程序
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
        }
        catch (ClassNotFoundException e)
        {
            System.out.println(e.getMessage());
        }
        try
        {
            Connection con= DriverManager.getConnection(url, "sa", "sasa");
            Statement stmt=con.createStatement();
            stmt.executeUpdate("insert into feed values("+
            "'idea','subject ','liuyan','name','email','tel','fox')");
            stmt.close();
            con.close();
        }
        catch (SQLException e)
        {
            System.out.println(e.getMessage());
        }
    }    public static void main(String args[])
    {
        feedbackjdbc jdbcTest = new feedbackjdbc();
        jdbcTest.insert();
    }
}

Answer 3

kk2486(龙) ( ) 我开始也是这样写的！~
但要在jsp中和数据库连接
所以才加insert方法zhgj8750(清风) ( ) 我刚试了还有错
D:\j2sdk1.4.0_03\bin>javac feedbackjdbc.java
feedbackjdbc.java:25: cannot resolve symbol
symbol  : class Connection
location: class feedbackjdbc
            Connection con= DriverManager.getConnection(url, "sa", "sasa");
            ^
feedbackjdbc.java:25: cannot resolve symbol
symbol  : variable DriverManager
location: class feedbackjdbc
            Connection con= DriverManager.getConnection(url, "sa", "sasa");
                            ^
feedbackjdbc.java:26: cannot resolve symbol
symbol  : class Statement
location: class feedbackjdbc
            Statement stmt=con.createStatement();
            ^
feedbackjdbc.java:32: cannot resolve symbol
symbol  : class SQLException
location: class feedbackjdbc
        catch (SQLException e)
               ^
4 errors

Answer 4

那你就不用写main方法了
  做成java bean 然后在jsp里面包含一下不就可以实现数据库连接了么？

Answer 5

我就是在用java bean package jsjdb;
import java.sql.*;
   public class feedbackjdbc   {
   public String idea;
   public String subject;
   public String liuyan;
   public String name;
   public String email;
   public String tel;
   public String fox;
   public void insert()
  {    
   
String url = "jdbc:microsoft:sqlserver://192.168.0.1:1433;DatabaseName=feedback";   try 
{ 
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
// 加载驱动程序
}
  catch (ClassNotFoundException e) 
{
System.out.println(e.getMessage());
} 
  try
{
 Connection con= DriverManager.getConnection(url, "sa", "sasa");
  Statement stmt=con.createStatement();

StringBuffer sql = new StringBuffer();
sql.append("insert into feed values('" + idea + "','" + subject + "','"
+ liuyan + "','" + name + "','" + email + "','" + tel + "','" + fox + "')");
 stmt.executeUpdate(sql.toString());
                          

 stmt.close();  
 con.close();
}
  catch (SQLException e) 
{
System.out.println(e.getMessage());
 }
 }
  
}
可以拉