程序有错但不知道是哪里的错，望大神帮忙查看一下?

程序有错但不知道是哪里的错，望大神帮忙查看一下？

  • 634

    浏览

  • 1

    关注

  • 0

    回答

初见
初见

来自：

package web;

 

import java.io.PrintWriter;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

 

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

 

public class AddServlet extends HttpServlet{

public void service(HttpServletRequest request,HttpServletResponse response){

java.sql.Connection conn=null;

try {

int biamma=Integer.parseInt(request.getParameter("biamma"));

String name=new String(request.getParameter("name").getBytes("ISO-8859-1"),"UTF-8");

String zhiwei=new String(request.getParameter("zhiwei "));

double xinshui=Double.parseDouble(request.getParameter("xinshui"));

double jiangjin=Double.parseDouble(request.getParameter("jiangjin"));

double ruzhi=Double.parseDouble(request.getParameter("ruzhi"));

double jingli=Double.parseDouble(request.getParameter("jingli"));

double bumen=Double.parseDouble(request.getParameter("bumen"));

request.setCharacterEncoding("utf-8");

response.setContentType("text/html;charset=utf-8");

PrintWriter out = response.getWriter();

out.print(biamma);

out.print(name);

out.print(zhiwei);

out.print(xinshui);

out.print(jiangjin);

out.print(ruzhi);

out.print(jingli);

out.print(bumen);

out.close();

Class.forName("com.mysql.jdbc.Driver");

conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/jsj","root","root");

 

String sql="insert into emp(biamma,name,zhiwei,xinshui,jiangjin,ruzhi,jingli,bumen) values(?,?,?,?,?,?,?,?)";

PreparedStatement pst=(PreparedStatement)conn.prepareCall(sql);

pst.setDouble(1, biamma);

pst.setString(2, name);

pst.setString(3,zhiwei);

pst.setDouble(4, xinshui);

pst.setDouble(5, jiangjin);

pst.setDouble(6, ruzhi);

pst.setDouble(7, jingli);

pst.setDouble(8, bumen);

pst.executeUpdate();

 

}  catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

System.out.println("catch-----------------");

 

}

 

}

}


<?xml version="1.0" encoding="UTF-8"?>

<web-app version="2.4" 

xmlns="http://java.sun.com/xml/ns/j2ee" 

xmlns:xsi="http://www.w3.org/2001/XMLSche ... sp%3B

xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee 

http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">

   <servlet>

   <servlet-name>AddServlet</servlet-name>

   <servlet-class>web.AddServlet</servlet-class>

</servlet>

 

<servlet-mapping>

   <servlet-name>AddServlet</servlet-name>

   <url-pattern>/add</url-pattern>

</servlet-mapping>

</web-app>


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

  <head>

    <title>add.html</title>

 

    <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">

    <meta http-equiv="description" content="this is my page">

    <meta http-equiv="content-type" content="text/html; charset=UTF-8">

 

    <!--<link rel="stylesheet" type="text/css" href="./styles.css">-->

 

  </head>

 

  <body>

   <body style="font-size:30px;">

  <form action="add" method="post">

  <fieldset>

 <legend>人员信息</legend>

  编码：<input name="bianma"/>       

  姓名：<input name="name"/>       

  职位：<input name="zhiwei"/>   

  薪水：<input name="xinshui"/>       

  奖金：<input name="jiangjin"/>       

  入职时间：<input name="ruzhi"/>       

  经理：<input name="jingli"/>       

 部门：<input name="bumen"/>       

 

  <input type="submit" value="确认"/>

  </fieldset> 

  </body>

</html>



2019-10-28

太寂寞了，都没有人过来聊~

为什么被折叠? 0 个回复被折叠
赞臣社区 用户中心