📄 lending.java
字号:
import java.sql.*;
import javax.servlet.*;
public class lending extends GenericServlet
{
Connection con;
public void init(ServletConfig sc)
{
try
{
super.init(sc);
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:sri","gscl","granada");
}
catch(Exception e){e.printStackTrace();}
}
public void service(ServletRequest req,ServletResponse res)
{
try
{
Statement st = con.createStatement();
String st1 = req.getParameter("lin");
String st2 = req.getParameter("lbn");
String st3 = req.getParameter("ldoi");
String st4 = req.getParameter("ldoe");
int j =st.executeUpdate("insert into issue values('"+st1+"','"+st2+"','"+st3+"','"+st4+"')");
ServletOutputStream sos = res.getOutputStream();
if(j>0)
sos.println("<html><body bgcolor = pink><h1>The data is added successfully</h1></body></html>");
else
sos.println("<html><body bgcolor = pink><h1>The data is not added</h1></body></html>");
}
catch(Exception ex){ex.printStackTrace();}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -