import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;public DemoConnection extends HttpServlet{
private static final String CONTENT_TYPE = "text/html; charset=GBK";
/**Initialize global variables*/
public void
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
PrintWriter out = response.getWriter();
Connection con = null;
Statement sta = null;
try {
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
con = DriverManager.getConnection("jdbc:mysql://localhost/mysql?user=root&password=password");
sta = con.createStatement();
String sql = "select * from users";
ResultSet rs = sta.executeQuery(sql);
if (rs.next())
{
out.println(rs.getString(1));
}
sta.close();
con.close();
}
catch(Exception e){
System.out.println(e.getMessage());}
}
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;public DemoConnection extends HttpServlet{
private static final String CONTENT_TYPE = "text/html; charset=GBK";
/**Initialize global variables*/
public void
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
PrintWriter out = response.getWriter();
Connection con = null;
Statement sta = null;
try {
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
con = DriverManager.getConnection("jdbc:mysql://localhost/mysql?user=root&password=password");
sta = con.createStatement();
String sql = "select * from users";
ResultSet rs = sta.executeQuery(sql);
if (rs.next())
{
out.println(rs.getString(1));
}
sta.close();
con.close();
}
catch(Exception e){
System.out.println(e.getMessage());}
}
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;public class Servlet1 extends HttpServlet
{
//building a simple web page to client.
public void service(HttpServletRequest request,
HttpServletResponse response)
throws IOException ,
ServletException
{
PrintWriter out;
String title="This is title of servlet";
String heading1="This is output1 from Servlet1";
// set content type.
response.setContentType("text/html");
out = response.getWriter();
// write data or building web page.
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");;
}
catch(ClassNotFoundException ce)
{
System.out.println("Not find the deiver");;
}
try
{
Connection con=DriverManager.getConnection("jdbc:odbc:person");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * from contact.csv ");
while(rs.next())
{
out.print(
"name "+rs.getString("Name")+
"\t"+"ID "+rs.getInt("ID")+
"\t"+"Address "+rs.getString("Address")+
"\t"+"Email "+rs.getString("Email"));
}
st.close();
con.close();
}
catch(SQLException e)
{
System.out.println("I am in the SQLException!");
}
out.print("<HTML><HEAD><TITLE>"+title+"</TITLE>");
out.print("</HEAD><BODY>");
out.print("<h1>"+heading1 +"</h1>");
out.println("<P>This is output2 from Servlet1.");
out.print("</BODY></HTML>");
//close out.
out.close();
}
}
import sun.servlet.http.*;
public class SimpleServletServer
{
public static void main(String[] args)
{
String[] arguments = {"-p","8080","-d","c:\\javaplus"};
HttpServer.main(arguments);
}
}----------------
解释一下!!!!!!!!!
第一次使用java 写服务器程序,见笑了!
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");;//这里设置服务器的驱动器
}
catch(ClassNotFoundException ce)
{
System.out.println("Not find the deiver");;假如异常 提示找不到驱动器
}
try
{
Connection con=DriverManager.getConnection("jdbc:odbc:person");//连接到数据库
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * fromcontact.csv ");//得到结果集
while(rs.next())//假如结果集还有结果继续操作
st.close();
con.close();//关闭连接
c:\\javaplus是什麼意思???
沒有:sun.servlet.http.*;