Venus AUEB Forum

Code: Select all

class Kati
{
     static double x[] = {0.1, 0.3, 0.4, 0.5, 0.6};

     public static double hermite(double x)
     {
            double gin = 1;
    	    for (int i=1; i<=n; i++)
      	     {
    		    if (i%2==0)
    			   gin*= (x-x[i/2-1]);          //line 40
    		    else 
    			   gin*= (x-x[i/2]);             //line 42
             }
             return gin;
      }
}

Code: Select all

Create procedure make_apoint
@prof_id int,
@cust_id int,
@apoint int,
@location varchar(30),
@description varchar(50),
@cal datetime
as
INSERT INTO apoint(prof_ID,cust_ID,apoint_ID,location,description,cal)
VALUES(@prof_id,@cust_id,@apoint,@location,@description,@cal)

Code: Select all

JSP CODE

String cu_id = request.getParameter("cu_id");
        String prof_id =request.getParameter("prof_id");
        String location=request.getParameter("location");
        String description=request.getParameter("description");
        String datetime=request.getParameter("date&time");
        java.util.Random r=new java.util.Random();
        int apoint_id=r.nextInt();

   String sql2="exec [Project Vaseis].dbo.make_apoint '"+prof_id+"','"+cu_id+"','"+apoint_id+"','"+location+"','"+description+"','"+datetime+"';";

Code: Select all

java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type varchar to datetime.

Code: Select all

CallableStatement proc = connection.prepareCall("{ call make_apoint(?, ?, ?, ?, ?, ?) }");
proc.setInt(1, prof_id);
...
...
...
proc.setDate(6, Date.parse(datetime))
proc.execute();